Question: D35fx begin{tabular}{c|c|c|c} A & A & B & C hline WC premium in & Payroll in & & Detropolitan end{tabular} begin{tabular}{|c|cccc} hline & thousands

D35fx \begin{tabular}{c|c|c|c} A & A & B & C \\
D35fx \begin{tabular}{c|c|c|c} A & A & B & C \\
D35fx \begin{tabular}{c|c|c|c} A & A & B & C \\ \hline WC premium in & Payroll in & & Detropolitan \end{tabular} \begin{tabular}{|c|cccc} \hline & thousands & thousands & Manufacturing & Metropolitan \\ \hline 2 & 7 & 380 & 0 & 0 \\ \hline 3 & 7.3 & 410 & 0 & 0 \\ \hline 4 & 7.8 & 443 & 0 & 1 \\ \hline 5 & 8.2 & 480 & 0 & 0 \\ \hline 6 & 8.5 & 520 & 0 & 1 \\ \hline 7 & 9.2 & 566 & 0 & 0 \\ \hline 8 & 9.9 & 616 & 1 & 0 \\ \hline 9 & 10.6 & 672 & 0 & 0 \\ \hline 10 & 11.4 & 733 & 1 & 1 \\ \hline 11 & 12.2 & 802 & 0 & 1 \\ 12 & 12.9 & 878 & 1 & 0 \\ \hline 13 & 13.5 & 963 & 0 & 1 \\ \hline 14 & 14.5 & 1057 & 1 & 1 \\ \hline 15 & 15.6 & 1161 & 1 & 0 \\ \hline 16 & 16.8 & 1277 & 1 & 1 \\ 17 & 17.3 & 1405 & 1 & 0 \\ 18 & 18.2 & 1548 & 1 & 0 \\ \hline 19 & 19.8 & 1706 & 1 & 1 \\ \hline 20 & 20.5 & 1882 & 1 & 1 \\ \hline 21 & 21.5 & 2077 & 0 & 0 \\ 22 & 23 & 2293 & 1 & 1 \\ 23 & 24.1 & 2534 & 1 & 1 \\ 24 & & & 1 & 0 \end{tabular} Refer to "Quiz 6-excel file" on Canvas and run the regressions required in Questions 1-10. Show your regression results in tables in "Quiz 6-excel file" and upload the spreadsheets on Canvas. If you just answer the questions without uploading your spreadsheets, you will receive only. 50% of the credit. Run a simple regression using payroll in thousands to predict workers compensation premiums in thousands with a 99% confidence interval. What statistic in the regression would you use to explain to thefisk manager how useful this model is in general? A) Multiple R 0.9880 B) R Square 0.9761 C) Adjusted R Square 0.9749 D) Standard Error 0.8566

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!