Im sorry, this is all I got please let me know if it helps.
Thoughts and insights to the week 6 lab
You can complete these calculations in Excel as well. When you open the data in the Excel format,
type "mean" in the column after "die10".
Then in cell X2 type =AVERAGE(N2:W2) to calculate the mean for that roll
of the die. Then use this same formula
to determine the average for all the remaining rows. In the next column to the right of that, type
"median" after the "mean". Then in cell
y2 type =MEDIAN(N2:W2) and use that same formula in the rows of that column.
Then under each of those columns (in my sheet this is in
cells X22 and Y22, type in =AVERAGE(X2:X21) and the same for the Y column. Under those cells, type in =STDEV(X2:X21) and
the same for the Y column so that you have the mean and standard deviation for
the mean and of the median.
We then need to find the confidence interval for the SLEEP
variable. Under that column, in cell
G22, type =AVERAGE(G2:G21). Under that
in cell G23, type =STDEV(G2:G21). Now
we can find the maximum error of the confidence interval. In cell G24, type
=CONFIDENCE.T(0.05,G23,20). The 0.05 is
1 minus the confidence interval, the C23 is the standard deviation, and 20 is
the number in our sample. You then need
to calculate the confidence interval from this
maximum error by subtracting it from the mean and adding it to the mean
as shown on page 320 of the text.
Finally, you can go one more cell down to G25 and type
=CONFIDENCE.T(0.01,G23,20) to find the maximum error for a 99% confidence
interval. Again, you would need to subtract
this and add it to find the actual confidence interval.
Question 1: list all the possible values when you roll a die
Question 2: this is calculated by hand using the formulas on
pages 194 and 195 of the text
Question 3: this is from Minitab or Excel and is based on
the mean of the means
Question 4: this is from Minitab or Excel and is based on
the mean of the medians
Question 5: from Minitab or Excel
Question 6: You can look to page 68 in the text for some
guidance on answering this question
Questions 7 and 8: from Minitab or Excel
Question 9: based on your understanding of confidence