You are part of a team investigating the identifying motor vehicle accidents. A multiple regression model...

90.2K

Verified Solution

Question

Basic Math

You are part of a team investigating the identifying motorvehicle accidents. A multiple regression model is to be constructedto predict the number of motor vehicle accidents in a town per yearbased upon the population of the town, the number of recordedtraffic offenses per year and the average annual temperature in thetown.

Data has been collected on 30 randomly selected towns:

Number of motor vehicle
accidents per year
Population
(× 1000)
No. of recorded
traffic offences
(× 100)
Average temperature
°F
3551812978
4902575682
5974413481
475509581
92249510282
7363816581
3051672584
1,12837819178
7453698676
4762376384
143100484
2031182179
90948910678
4102103977
64213813181
84730813882
6044184077
71919413278
350319884
327706176
1,03825919278
75629911581
6354404079
79628313185
301645681
135262679
6393115081
3252101377
441439879
5223702682

a)Find the multiple regression equation using all threeexplanatory variables. Assume that X1 is population,X2 is number of recorded traffic offenses per year andX3 is average annual temperature. Give your answers to 3decimal places.

y^ =  + population + no. traffic offences + averagetemp

b)At a level of significance of 0.05, the result of the F testfor this model is that the null hypothesis isis not rejected.

For parts c) and d), using the data, separately calculate thecorrelations between the response variable and each of the threeexplanatory variables.

c)The explanatory variable that is most correlated with numberof motor vehicle accidents per year is:

population
number of traffic offenses
average annual temperature

d)The explanatory variable that is least correlated with numberof motor vehicle accidents per year is:

population
number of traffic offenses
average annual temperature

e)The value of R2 for this model, to 2 decimalplaces, is equal to

f)The value of se for this model, to 3 decimalplaces, is equal to

g)Construct a new multiple regression model by removing thevariable average annual temperature. Give your answers to 3 decimalplaces.

The new regression model equation is:

y^ =  + population + no. traffic offences

h)In the new model compared to the previous one, the value ofR2 (to 2 decimal places) is:

increased
decreased
unchanged

i)In the new model compared to the previous one, the value ofse (to 3 decimal places) is:

increased
decreased
unchanged

Answer & Explanation Solved by verified expert
3.7 Ratings (451 Votes)
All analysis is carried out in excel softwarea The multiple regression equation for three explanatoryvariables is describe aswhere y is number of motor vehicle accidents x1 ispopulation x2 is number of recorded traffic offensesper year and x3 is average annual temperatureThe resulted outcome is using OLS method under excelcommandSUMMARY OUTPUTRegression    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students