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. Section Exercise 12-12 The regression equation Nerfncome= 2,277 + .0307 Revenue was estimated from a sample of 100 leading world companies {variables are in millions of dollars}. Click here forthe Excel Data File la-'ll If Revenue: 1. then Netlncome = million. [Round your answer to 2 decimal places} [a-2} Choose the correct statement. 0 Decreasing the revenue raises the net income. O Increasing the revenue lowers the net income. O Increasing the revenue raises the net income. lb} Choose the right option. 0 "he intercept is not meaningful because a rm cannot have net income when revenue is zero. 0 "he intercept is meaningful because a firm can have net income when revenue is zero. (1:) If Revenue: 20,000, then Nermcome= million. (Round your answer to the nearest whole number.} Section Exercise 12-14 The regression equation Credits = 15.4 - .07 Work was estimated from a sample of 21 statistics students. Credits is the number of college credits taken and Work is the number of hours worked per week at an outside job. (Round your answers to 1 decimal place.) Click here for the Excel Data File (a) Choose the correct statement. O An increase in the number of hours worked per week increases the expected number of credits. O A decrease in the number of hours worked per week decreases the expected number of credits. O An increase in the number of hours worked per week decreases the expected number of credits. (b) Choose the right option. O The intercept is meaningful as a student may not have a job outside of school. O The intercept is not meaningful as a student who works outside may not earn any credits. (c)If Work = 0, then Credits = If Work = 40, then Credits =Section Exercise 12-26 A regression was performed using data on 16 randomly selected charities. The variables were Y: expenses [millions of dollars} and X = revenue [millions ofdollars]. Variables coefficients Std. Error Intercept ?.6425 18.6403 Revenue 6.946? 9.6936 Epicture Click here for the Excel Data File to] Write the tted regression equation. [Round your answers to 4 decimal places: it} :+:X lb} Construct a 95% confidence interval for the slope- (Round your answers to 4 decimal places} The 95% confidence interval is from |:| to |:|. [c] Choose the appropriate hypotheses and decision rule for a righttailed t test for zero slope at U = .05. a. He: ,61 S 0 versus H1: :81 > 0. Reject the null hypothesis if tcalc