Assess The Questions Using Both Excel And Spss Software Results From These Programs Should Be Copied And Pasted
assess the questions using both Excel and SPSS software. Results from these programs should be copied and pasted
with statements amd data and input information benefits.
A manager of a food manufacturing company wants to estimate the percentage of fat in one of its salad dressings. A sample of 20 bottles was taken and the results are given below.
15.88 19.88 21.16 20.37 22.77 20.65
18.60 18.91 21.77 21.64 18.62 18.41
20.15 17.07 19.91 21.07 16.49 21.21
a. Use Excel to calculate the mean, median, and standard deviation for these data.
b. Use SPSS to calculate the mean, median, and standard deviation for these data.
c. Use SPSS to develop a histogram of these data.
d. Interpret these results and explain whether or not it is honest for the manufacturer to state that the fat content is 20%? Explain your answer.
Statistics and Probability