Perform Linear Regression Analysis for all three tabs: a. Ln Safety Belt Rate Fatalities Ln Safety Belt Rate 1071 3.951243719 1138 4.058717385 996 4.257030144 991 4.374498368 1038 4.365643155 1004 4.348986781 1154 4.382026635 1148 4.404277244 1207 4.417635062 1110 4.410371108 969 4.455509411 848 4.49980967 862 4.515245478 895 4.477336814 865 4.494238625 853 4.577798989 820 4.561218298 850 4.535820108 1083 4.521788577 948 4.531523646 953 4.519612298 856 4.525044142 b. Ln Unemployment Rate Fatalities Ln Unemployment Rate 1071 1.504077397 1138 1.547562509 996 1.526056303 991 1.648658626 1038 1.774952351 1004 1.791759469 1154 1.722766598 1148 1.481604541 1207 1.386294361 1110 1.410986974 969 1.757857918 848 2.312535424 862 2.341805806 895 2.261763098 865 2.104134154 853 1.987874348 820 1.902107526 850 1.808288771 1083 1.774952351 948 1.526056303 953 1.360976553 856 1.098612289 c. Ln Median Income Fatalities Ln Median Income 1071 10.49863594 1138 10.49822225 996 10.47514484 991 10.46766435 1038 10.53483911 1004 10.52554144 1154 10.50859556 1148 10.52271905 1207 10.54407748 1110 10.65045982 969 10.702705 848 10.59613461 862 10.61969186 895 10.65937476 865 10.67968829 853 10.76468832 820 10.65202214 850 10.70344669 1083 10.76259399 948 10.83693034 953 10.81849746 856 10.93667204 3- Determine the strongest model based on R-Square. Also, interpret the result. 4- Which variable amongst the three has the strongest linear relationship? (HINT: Scatter plots) All your work including excel sheet plus the answers to the above questions. You can write the answers on a separate sheet of paper or on excel.

Algebra & Trigonometry with Analytic Geometry

13th Edition

ISBN:9781133382119

Author:Swokowski

Publisher:Swokowski

Chapter4: Polynomial And Rational Functions

Section4.6: Variation

Problem 37E

See similar textbooks

Related questions

Question

100%

Perform Linear Regression Analysis for all three tabs:
a. Ln Safety Belt Rate

Fatalities	Ln Safety Belt Rate
1071	3.951243719
1138	4.058717385
996	4.257030144
991	4.374498368
1038	4.365643155
1004	4.348986781
1154	4.382026635
1148	4.404277244
1207	4.417635062
1110	4.410371108
969	4.455509411
848	4.49980967
862	4.515245478
895	4.477336814
865	4.494238625
853	4.577798989
820	4.561218298
850	4.535820108
1083	4.521788577
948	4.531523646
953	4.519612298
856	4.525044142

b. Ln Unemployment Rate

Fatalities	Ln Unemployment Rate
1071	1.504077397
1138	1.547562509
996	1.526056303
991	1.648658626
1038	1.774952351
1004	1.791759469
1154	1.722766598
1148	1.481604541
1207	1.386294361
1110	1.410986974
969	1.757857918
848	2.312535424
862	2.341805806
895	2.261763098
865	2.104134154
853	1.987874348
820	1.902107526
850	1.808288771
1083	1.774952351
948	1.526056303
953	1.360976553
856	1.098612289

c. Ln Median Income

Fatalities	Ln Median Income
1071	10.49863594
1138	10.49822225
996	10.47514484
991	10.46766435
1038	10.53483911
1004	10.52554144
1154	10.50859556
1148	10.52271905
1207	10.54407748
1110	10.65045982
969	10.702705
848	10.59613461
862	10.61969186
895	10.65937476
865	10.67968829
853	10.76468832
820	10.65202214
850	10.70344669
1083	10.76259399
948	10.83693034
953	10.81849746
856	10.93667204

3- Determine the strongest model based on R-Square. Also, interpret the result.
4- Which variable amongst the three has the strongest linear relationship? (HINT: Scatter plots)

All your work including excel sheet plus the answers to the above questions. You can write the
answers on a separate sheet of paper or on excel.

Expert Solution