NOTE â€“ All datasets for this assignment were drawn from online datasets for use in statistics courses.
1. Download the file â€œChoclolate.xlsxâ€ from Canvas. This file contains data on the weights of chocolate pieces from a factory. The target weight for these are 20 oz. Perform the following analyses on these data:
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlinesOrder Paper Now
a. Compute descriptive statistics on these data (including scatter plot).
b. Plot a histogram of the data (create the plot yourself â€“ do not use the excel built-in histogram function)
c. Compute the 95% confidence interval for the sample mean
d. Determine if the mean of this sample is statistically different from the 20 oz target using the t-Distribution.
2. Download the file â€œFlow Meter.xlsxâ€ from Canvas. This file contains data regarding pressure and weight in cryogenic flow meters. Perform a linear regression analysis on these data. Calculate the coefficients of the linear model on your own and check your work using the built-in excel function.
3. Download the file â€œFootball vs Basketball Heights.xlsxâ€ from Canvas. The file contains heights for basketball and football players. Perform a t-test to determine if the heights between these groups are statistically different.
4. Download the file â€œSample_Dataset_2014.xlsx.â€ Ask two questions of the data (one regression and one hypothesis test), and perform an appropriate statistical test to answer the question.