Copy the following monthly return data for Tesla Inc. and S&…

Copy the following monthly return data for Tesla Inc. and S&P 500 Index to your Excel file:   S&P 500 Tesla Inc. 03/25 -5.75% -11.54% 02/25 -1.42% -27.59% 01/25 2.70% 0.19% 12/24 -2.50% 17.00% 11/24 5.73% 38.15% 10/24 -0.99% -4.50% 09/24 2.02% 22.19% 08/24 2.28% -7.74% 07/24 1.13% 17.28% 06/24 3.47% 11.12% 05/24 4.80% -2.84% 04/24 -4.16% 4.26% 03/24 3.10% -12.92% 02/24 5.17% 7.79% 01/24 1.59% -24.63% 12/23 4.42% 3.50% 11/23 8.92% 19.54% 10/23 -2.20% -19.73% 09/23 -3.65% -3.05% 08/23 6.47% -3.50% 07/23 0.25% 2.16% 06/23 1.46% 28.36% For the data above, calculate the correlation, covariance, slope, intercept, and R-squared in Excel. Choose the right answer for each from the drop-down menus below.  The slope coefficient of the regression analysis, where Tesla Inc. stock returns are the dependent variable and S&P 500 returns are the independent variable, is [slope]. The intercept coefficient of the regression analysis, where Tesla Inc. stock returns are the dependent variable and S&P 500 returns are the independent variable, is [intercept]. The R-squared for the regression analysis, where Tesla Inc. stock returns are the dependent variable and S&P 500 returns are the independent variable, is [R-squared].  Make sure to answer all five questions! Save your work in MS Excel and submit your Excel file at the end of the exam.

A manufacturer claims that a machine produces metal discs wi…

A manufacturer claims that a machine produces metal discs with an average diameter of 10 cm, with a population standard deviation of 1.25 cm. A quality control team takes a random sample of 40 rods, finding an average length of 9.5 cm. At a 5% significance level, test whether the machine’s production differs from the claimed mean of 10 cm. The proper test for this hypothesis test is [test]. The alternative hypothesis, H1, is [alternative_hypothesis]. The value for the test statistic is [test_statistic]. The p-value for this hypothesis test is [p-value]. The correct statistical decision is to [decision]. Hint: Choose the correct answer for each question from the drop-down menus above. Make sure to answer all five questions! Save your work in MS Excel and submit your Excel file at the end of the exam.  

A regional distribution center has been struggling to keep i…

A regional distribution center has been struggling to keep its on-time delivery key performance indicator (KPI). The operations director is evaluating whether their newer vendor, RapidRoute Logistics, is actually delivering faster than the long-standing supplier, FleetFirst Transport. A faster average delivery time would help the director justify reallocating more volume to RapidRoute in next year’s budget cycle.To make a data-driven call, the director samples recent delivery records from both suppliers. RapidRoute Logistics (Supplier R): Sample mean = 4.1 days Sample standard deviation = 1.4 days Sample size = 35 FleetFirst Transport (Supplier F): Sample mean = 4.5 days Sample standard deviation = 1.2 days Sample size = 32 Assume population standard deviations are unknown and unequal. Determine whether there is statistical evidence at the 95% confidence level that RapidRoute’s average delivery time is faster than FleetFirst’s. The proper test for this hypothesis test is [test]. The alternative hypothesis, H1, is [alternative_hypothesis]. The p-value for this hypothesis test is [p-value]. The correct statistical decision is to [decision].