Need help answering questions...can;'t upload excel files will need to do problems manually.
(a) Calculate SSxx, SSyy, and SSxy. (Leave no cells blank - be certain to enter "0" wherever required.) Click here for the Excel Data File College Student Weekly Earnings in Dollars (n = 5) Hours Worked (X) Weekly Pay (Y) (4 - y) (mi - x) (yi - y) 10 93 15 171 20 204 20 156 35 261 y $5xx 55yy 55xy (b) Calculate the sample correlation coefficient. Check your work by using Excel's function =CORREL(array1, array2). (Round your answer to 4 decimal places.) (c) Find t. 925 for a two-tailed test for zero correlation at a = .05. (Round your answer to 3 decimal places.) t. 025 (d-1) Calculate the t test statistic. (Round your answer to 3 decimal places.) tcalc (d-2) Should we reject the null hypothesis of zero correlation? O Yes O No (e) Use Excel's function =T.DIST.2T(t, deg_freedom) to calculate the two-tail p-value. (Round your answer to 4 decimal places.) p-valueSection Exercise 12-4 Using the data given in the table below, answer the following questions. (Round your final answers to 3 decimal places.) Moviegoer Snack Spending (n = 10) Age (X) Spent (Y) 30 6.85 50 10.50 34 5,50 12 10.35 37 10.20 33 10.75 36 7.60 26 10.10 18 12.35 46 8.35 Click here for the Excel Data File (a) Use Excel, MegaStat, or MINITAB to calculate the correlation coefficient. (A negative value should be indicated by a minus sign.) calc (b) Use Excel or Appendix D to find to25 for a two-tailed test at a = .05. t.025 (c) Calculate the t test statistic. (A negative value should be indicated by a minus sign.) tcalc (d) Should we reject the null hypothesis of zero correlation? O Yes O NoSection Exercise 12-8 The fitted regression is Sales = 842 - 37.5 Price. (a-1) If Price = 1, then Sales = (Round your answer to 1 decimal place.) (a-2) Choose the correct statement. O An increase in price increases sales. O A decrease in price decreases sales. O An increase in price decreases sales. (b) If Price = 20, then Sales = (c) Choose the right option. O The intercept is not meaningful as a zero price is unrealistic. O The intercept is meaningful as sales will be maximum when price is zero.Section Exercise 12-10 The fitted regression Computer power dissipation = 15.73 + 0.032 Microprocessor speed, where Computer power dissipation is measured in watts and Microprocessor speed is measured in MHZ. la-1} If Microprocessor speed: 1 MHZ. then Computer power dissipation = |:| watts. (Round your answer to 3 decimal places} [ll-2} Choose the correct statement. 0 A decrease in the microprocessor speed decreases the computer power diss'pation. C) An increase in the microprocessor speed decreases the computer power dissipation. O An increase in the microprocessor speed increases the computer power dissisation. lb} If Microprocessor speed = 3,000 MHZ, then Computer power dissipation = watts. {Round your answer to 2 decimal place 5.} (1:) Choose the right option. O The intercept would not be meaningful because you would not have a computer with zero speed. 0 The intercept would be meaningful because you would have a computer with zero speed
