View the step-by-step solution to:

Question

Please help me verify. Data for the spreadsheet is at the bottom.


1.What do you estimate the

number of bike rentals will be if the 'feels like' temperature is 41, the humindity is 57.7%, the windspeed is 27.8, the day is considered a holiday (1) and is a working day (1) and the weather is of type 3? Report your answer


Answer: (157.549513) + (-85.88732956) + ( 16.32800514 * 3)+ ( 7.643271095*41)+( -2.325852106*57.7)+( 0.590520174*27.8) = 316.2351081


2) All other things being equal, what change in the number of rentals do you estimate for an extra unit of windspeed? Enter the lower end of a 95% confidence interval on the worth of an extra windspeed and enter the upper end of the interval.


Answer: Windspeed 0.59052, Lower -2.289621606, Upper 3.470662


3) What proportion of variation in the number of bike rentals is explained by your regression model (by the independent variables)?

Answer: 0.329778751 R squared Value


4)Test to see if the overall model is significant (i.e., if any of the independent variables are related to count) at the 0.01 level of significance.

Answer: H0: None of the independent variable is related to number rented, Ha: At least one of the independent variables is related to number rented


5) What is the P-Value

Answer: 1.84237E-09


6) All other things being equal, how many more (less) rentals do you estimate will happen if the weather is of type 2 compared to weather of type 1?

Answer: 4.252456- 0.444135= 3.808321


7)State whether or not the difference in rentals between the two weather types is significant at the 0.01 level of significance; indicate the p-value you used to make your conclusion.

Answer: Not Significant (does not add explanatory power), P Value of type 2 weather vs type 1 = 0.435972496


Instructions:

Use a regression model that can be used to predict the total number of rentals ("count") as a function of the other factors in the data set.   When creating the regression model, assume that, "weekend" (0) is the base case for "working day," and weather type 1 is the base case for "weather." 


Data For Calculations:

Bike Rental Count 43 23 15 3 116 108 64 43 84 82 8 6 3 89 34 112 1 310 3 77 349 25 148 122 59 154 72 378 127 202 291 82 295 39 456 226 274 154 477 155 116 327 6 263 14 595 25 138 29 7 11 162 77 17 20 361 89 285 4 189 381 27 323 180 175 2 120 90 15 17 204 188 232 24 217 58 216 75 4 63 288 72 96 48 265 8 116 324 32 178 2 8 191 302 54 132 31 250 77 4 354 42 615 163 678 124 244 775 38 301 222 647 394 219 59 239 338 527 397 324 286 344 150 11 177 146 125 387


working day 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 0 1 0 1 1 1 0 1 1 0 1 1 1 1 0 0 0 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 0 1 1 1 1 0 0 1 0 1 0 0 0 1 1 0 0 1 1 0 1 0 1 1 1 1 0 0 0 0 0 1 0 0 1 1 1 1 1 0 1 1 1 1 1 0 0 1 1 1 0 1 1 0 0 1


weather 1 2 1 3 2 2 1 1 1 1 1 1 1 1 1 2 2 2 1 1 1 3 3 2 2 2 1 1 2 2 1 3 2 2 1 3 1 1 2 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 3 1 3 3 1 1 2 1 1 2 2 2 3 3 2 2 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 2 3 1 1 1 1 1 1 2 1 2 1 2 1 1 1 2 3 1 2 2 2 1 2 1 1 1 1 1 1 2 1 1 1 2


temp 9.85 9.85 6.82 10.605 11.365 12.12 9.85 7.575 14.395 22.725 22.725 20.455 8.335 13.635 9.09 18.94 15.15 22.725 25 15.91 22.725 15.91 15.15 24.24 21.97 32.575 20.455 31.06 26.515 31.06 25.76 24.24 25.76 25 29.545 28.79 25.76 40.91 31.82 43.94 37.12 34.85 31.06 34.85 33.335 32.575 33.335 39.395 31.06 34.85 31.06 34.09 31.06 28.79 29.545 37.88 25.76 28.79 25.76 33.335 32.575 20.455 27.275 29.545 27.275 26.515 25.76 25.76 25.76 20.455 18.18 27.275 15.91 21.21 14.395 12.88 11.365 14.395 15.15 12.88 15.15 24.24 10.605 18.94 22.725 13.635 12.88 15.91 16.665 21.21 10.605 6.06 10.605 14.395 15.91 17.425 9.09 16.665 13.635 10.605 18.94 21.97 25.76 20.455 31.06 25.76 31.06 30.305 25.76 22.725 34.09 31.06 33.335 27.275 31.82 39.395 40.91 40.91 38.635 37.12 34.85 33.335 29.545 25.76 20.455 16.665 21.21 26.515


humidity 51 59 50 93 93 81 37 45 26 28 67 17 27 52 75 18 93 59 34 53 31 87 93 72 77 58 82 38 37 38 60 88 94 100 73 78 88 37 61 40 75 55 57 26 79 37 74 56 74 52 54 48 65 83 73 66 94 89 94 51 70 82 49 73 78 83 94 94 94 82 53 46 61 88 45 52 44 56 81 80 35 72 75 66 51 75 65 57 42 38 80 50 52 70 61 50 37 32 36 41 23 88 19 40 33 56 33 25 32 72 58 38 48 68 54 49 50 42 52 52 66 79 89 77 66 53 58 68


wind speed 12.998 12.998 12.998 0 0 8.9981 27.9993 0 16.9979 27.9993 16.9979 27.9993 31.0009 15.0013 26.0027 0 11.0014 11.0014 27.9993 12.998 8.9981 15.0013 16.9979 8.9981 8.9981 30.0026 22.0028 16.9979 6.0032 16.9979 8.9981 8.9981 12.998 0 19.0012 16.9979 12.998 12.998 8.9981 16.9979 12.998 0 0 0 6.0032 8.9981 15.0013 22.0028 0 11.0014 8.9981 22.0028 8.9981 0 7.0015 22.0028 26.0027 0 7.0015 11.0014 7.0015 8.9981 12.998 12.998 12.998 19.0012 22.0028 7.0015 8.9981 0 0 7.0015 19.0012 16.9979 15.0013 15.0013 11.0014 16.9979 0 6.0032 0 22.0028 11.0014 0 19.9995 0 12.998 15.0013 8.9981 19.9995 8.9981 19.0012 30.0026 12.998 7.0015 11.0014 39.0007 19.0012 23.9994 23.9994 0 0 26.0027 23.9994 19.9995 12.998 23.9994 19.0012 11.0014 0 30.0026 19.9995 15.0013 12.998 7.0015 19.0012 19.9995 19.9995 23.9994 30.0026 16.9979 8.9981 16.9979 7.0015 11.0014 8.9981 19.9995 16.9979

Top Answer

except for #6 , all... View the full answer

reg_bike.PNG

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question