View the step-by-step solution to:

# Problem A group of legislators wanted to look at factors that affect the number of traffic fatalities. They collected some data for 1994 from the...

Hi I have a multiple regression statistics problem I am looking for assistance on. File is attached

Problem A group of legislators wanted to look at factors that affect the number of traffic fatalities. They collected some data for 1994 from the National Transportation Safety Board on the number of fatalities for 50 states and the District of Columbia (DC), the number of licensed drivers, the number of registered vehicles, and the number of vehicle miles traveled. State Traffic Fatalities Licensed Drivers (thousands) Registered Vehicles (thousands) Vehicle Miles Traveled (millions) AL 1083 3043 3422 48956 AK 85 443 508 4150 AZ 903 2654 2980 38774 AR 610 1770 1560 24948 CA 4226 20359 23518 271943 CO 585 2620 3144 33705 CT 310 2205 2638 27138 DE 112 512 568 7025 DC 69 366 270 3448 FL 2687 10885 10132 121989 GA 1426 4666 5638 82822 HI 122 742 781 7935 ID 249 779 1062 11652 IL 1554 7548 8331 92316 IN 974 3834 4850 62108 IA 478 1921 2929 25737 KS 442 1794 1965 24678 KY 778 2498 2615 39822 LA 838 2606 3242 37430 ME 188 916 1071 12469 MD 651 3311 3543 44165 MA 440 4209 3956 46990 MI 1419 6602 7599 85183 MN 644 2668 3869 43317 MS 791 1659 2056 28548 MO 1089 3512 4179 57288 MT 202 536 967 9116 NE 271 1154 1490 15466 NV 294 987 983 13019 NH 119 878 1013 10501 NJ 761 5521 5752 60466 NM 447 1162 1472 20480 NY 1658 10444 10428 112970 NC 1431 4779 5462 71928 ND 88 443 687 6338 OH 1371 7722 9647 98200 OK 687 2363 2863 36980 OR 490 2401 2748 29453 PA 1441 8146 8557 92347 RI 63 682 728 7095
State Traffic Fatalities Licensed Drivers (thousands) Registered Vehicles (thousands) Vehicle Miles Traveled (millions) SC 847 2458 2764 37245 SD 154 512 845 7631 TN 1214 3583 5150 54524 TX 3186 12012 13287 178348 UT 342 1203 1381 18078 VT 77 435 502 6152 VA 930 4631 5593 67609 WA 638 3741 4654 47428 WV 356 1317 1375 17112 WI 712 3542 4044 50273 WY 144 354 583 6689 Source: Statistical Abstract of the United States 1996 (Reference: Pelosi and Sadifer, Doing Statistics for Business with Excel, Second Edition) (a) Copy and paste the data from this document to an Excel file. Select the Number of Traffic Fatalities as the dependent variable. Do a scatter plot between the Number of Traffic Fatalities and Number of licensed drivers (in thousands), a second scatter plot between the Number of Traffic Fatalities and the Number of Registered Vehicles (in thousands) and a third scatter plot between the Number of Traffic Fatalities and the Number of Vehicle Miles Traveled (in millions). Paste the scatter plots below and discuss the nature of the relationship based on the scatter plots. Note: Follow the instructions given in module 4 to do the scatter plots. (b) Select the Number of Traffic Fatalities as the dependent variable and the Number of licensed drivers (in thousands), the Number of Registered Vehicles (in thousands) and the Number of Vehicle Miles Traveled (in millions) as independent variables. Conduct multiple regression using Excel. Paste the output report below. Note: Follow the instructions given in module 4 to conduct simple regression. At the step where you specify the input data range, instead of selecting the data for one independent variable, select data for all the independent variables. (c) Write the equation from the regression output report. If you are using symbols in the equation for the variables, do define the symbols before using the symbols in the equation. Provide clear and complete interpretation of the coefficients b 1 , b 2 and b 3 in the equation. There is no need to interpret b 0 .
Show entire document

### 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.

### -

Educational Resources
• ### -

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