1.Suppose a regional market analyst believes the median repair cost estimates for Garage 1 is below that for Garage 2 (or the probability distribution of repair cost estimates for Garage 1 is shifted to the left of the probability of repair cost estimates for Garage 2). Use the Wilcoxon Signed Rank Test at the 0.05 level on the observations below to test this claim?

Repair Repair

CostCost

EstimateEstimate

Sample of CarsGarage 1Garage 2

Car 1$710$790

Car 2$900$ 1010

Car 3$ 1100$ 1220

Car 4$890$880

Car 5$990$ 1040

Car 6$910$980

Car 7$ 1030$ 1170

A random sample of 303 individuals was asked to indicate how often people become sick due to contaminated food. The following information for male and female respondents along with the rank sums were calculated:

GenderSample SizeSum of Ranks

Male10714059.5

Female19631996.5

Do men and women have systematically different responses? Use the Wilcoxon Rank Sum test at the 0.05 level

1.Suppose we have the following annual sales data for an automobile dealership:

YearSalesTrend

2011 1211

2012 1872

2013 1653

2014 1344

2015 1555

2016 1676

2017 2007

2018 2068

2019 2219

2020 23110

We want to forecast sales for 2021 and 2022 using either a simple trend model or a quadratic trend model. Use a within sample forecasting technique to determine the best model using the RMSE measure discussed in lecture. Once this model has been determined, provide actual forecasts for 2021 and 2022. Report the two RMSE values in your submission along with the actual forecasts. Submit your Excel file used to create these answers

1.Suppose that weekly expenses for two student organizations are thought to be similar. A random sample of 10 weeks yields the following weekly expenses for each organization:

Organization AOrganization B

$ 119.25$ 111.99

$ 123.71$ 116.62

$ 121.32$ 114.88

$ 121.72$ 115.38

$ 122.34$ 115.11

$ 122.42$ 114.40

$ 120.14$ 117.02

$ 123.63$ 113.91

$ 122.19$ 116.89

$ 122.44$ 121.87

Use a Wilcoxon Rank Sum Test to determine whether expenses differ for the two organizations. Test at the 0.05 level