Hello im really struggling with statistics. pls help me with this practice question.
im so losttt...
thank you so muchh
Shown here are the average prices per year for several metals over a period of 12 years: Gold (S per Copper (9: | Silver {5 per Aluminum [1: oz) per lb) oz) per lb) 161.1 64.2 | 4.4 39.8 308.0 93.3 | 11.1 61.0 613.0 101.3 | 20.6 21.6 460.0 84.2 | 10.5 26.0 326.0 22.8 | 8.0 26.0 424.0 26.5 | 11.4 22.8 361.0 66.8 | 8.1 81.0 318.0 62.0 | 6.1 81.0 368.0 66.1 | 5.5 81.0 448.0 82.5 | 2.0 22.3 438.0 120.5 | 6.5 110.1 382.6 130.9 | 5.5 82.8 The following is the summary statistics for the table above generated from an Excel regression analysis: SUMMARY OUTPUT Regression Statistics Multiple R 0.90 5828 36 R Sq uare 0. 82052 501 2 Adjusted R Square 0. 253221898 Standard Error 53 .438592 26 Observations 12 ANOVA {if 55 MS F Significance F Regression 3 104445.0636 34815.0212 12.19148582 0.002362638 Residual 8 2284 5.465 52 2855.683196 Total 11 122,290.5291200 Coefficients 5:23:36 E Stat P- vaiue Lower 95% Upper 95% Intercept -51.52488659 82.82443921 -0.582249825 0.523232262 -254.0'984066 1 50. 94863 34 Copper 0.069633112 0. 825259899 0.029552069 0. 938543643 -1.948219834 21182986059 Silver 18.28348992 3 .803 83 211 4.93 803 2403 0. 001 132869 10.01 1825 82 22.55515403 Aluminum 3.532815936 1.162805532 3.029456393 0016322908 0. 844851549 6. 23 02803 22 Based on the Excel output, does there appear to be a significant linear relationship between the price of Gold and at l'easi.l one of the prices of Copper, Silver, or Aluminum? Use the F-test for the population slope at 5% significance level. {a} State the null and alternative hypotheses, and identify which one is the claim. Hu_-[:] Which one is the claim: OH.) 0H1 For part (b), round your answer to 5 decimal places. {b} What is the test Pvalue that should be used in your hypothesis test? :] {c} Is the null hypothesis rejected? 0 No 0 Yes {d} Is the claim supported? 0 Yes, there is sufficient evidence to support the claim that linear relationship between the price of Gold and at ieast one of the prices of Copper, Silver, or Aluminum. 0 No, there is not sufficient evidence to support the claim that a linear relationship between the price of Gold and at least one of the prices of Copper, Silver, or Aluminum. For part (e), round your answers to 4 decimal places. {e} Write the regression equation below. i=1+ i=2+| 123 For part (f), round your final answer to 2 decimal places. =| Make sure you use correct units in your calculation. {1'} What would be the most likely price of gold per ounce if the price of copper is $1 per pound, the price of silver is $20 per ounce, and the price of aluminum is $1 per pound? :1 Ho: Select an answer v V Select an answer ? v Select an answer All three of Bi,B:, and B: 2 At least one of Bi, B:, or B: B1=32H: Select an answer v ? V Select an answer Select an answer At least one of B:, B:, or B: All three of B:, B:, and B: 12 Bi#B
