1_Part time student work values are described on the table below:

Hrs Worked Weekly Pay (Y)

10 93

15 171

20 204

20 156

35 261

20 177

Please transfer this data to Excel and run the Data Analysis Toolpack Regression test. Then determine the value of R2: ________

https://openstax.org/books/introductory-business-statistics/pages/13-1-the-correlation-coefficient-rLinks to an external site.

2_Given the data from Question1 and run the Data Analysis Toolpack Regression test. Then determine the Standard Error: ________

3_ Given the data from Question1 and run the Data Analysis Toolpack Regression test. Then determine the Regression Sum of Squares: ________

4_ Given the data from Question1 and run the Data Analysis Toolpack Regression test. Then determine the Intercept Coefficient: ________

5_ Given the data from Question1 and run the Data Analysis Toolpack Regression test. Then determine the Weekly Pay t-Statistic: ________

https://openstax.org/books/introductory-business-statistics/pages/13-1-the-correlation-coefficient-r