1) [25 pts.] At the 0.05 significance level, can you conclude the workforce is successful?

Question

Schadek Co. asked you to analyze their sales orders for the years 2018 and 2019 to see how well their sales force is working, and if they increased the sales orders or not. Use the data set in OnlineHW.xlsx. Worksheet ORDER. Sales orders of randomly selected customers (Schadek is a B2B co) are listed for 50 states.

1)     [25 pts.] At the 0.05 significance level, can you conclude the workforce is successful?

required informations are in the link;

https://drive.google.com/file/d/1eVWgXDwQo8yR7afi8qrWKyMCtxwkaE4u/view?usp=sharing

Answer 1

I used Minitab statistical software to run a 2-Sample or a.k.a. Paired "t" hypothesis test, and obtained a p-value of 0.054 which is greater than the alpha at 0.05, thus we would not reject the null hypothesis which states that there is no difference or change in the means between 2019 and 2018 sales data, so we can not conclude if there was success between 2019 and 2018 fiscal sales performance.

I used samples rather than z-distribution, as we are using randomly selected customers from each of the 50 states and samples taken from the customer population and we are not told about the standard deviation of the customer population, thus a t-distribution is required for the analysis.

Regards,

Mr. Patterson

You can also run this 2-Sample t test using MS Excel Data Analysis feature to conduct the hypothesis test as well.