Calculations for a set of variables
Ø Open the class surveyresults that were entered into the MINITAB worksheet.
Ø We want to calculate themean for the 10 rolls of the die for each student in the class. Label thecolumn next to die10 in the Worksheet with the word mean. Pull up Calc >Row Statistics and select the radio-button corresponding to Mean. For Input variables: enter all 10 rows of the die data. Go to the Store result in: and select the mean column. Click OK and the mean for each observation will show up in the Worksheet.
Ø We also want to calculatethe median for the 10 rolls of the die. Label the next column in theWorksheet with the word median.Repeat the above steps but select the radio-button that corresponds to Median and in the Store results in: text area, place the median column.
Calculating Descriptive Statistics
Ø Calculate descriptive statisticsfor the mean and median columns that where created above. Pull up Stat > Basic Statistics > DisplayDescriptive Statistics and set Variables:to mean and median. The output will show up in your Session Window. Print thisinformation.
Calculating Confidence Intervals for oneVariable
Ø We are interested incalculating a 95% confidence interval for the hours of sleep a student gets.Pull up Stat > Basic Statistics >1-Sample t and set Samples incolumns: to Sleep. Click the OKbutton and the results will appear in your Session Window.
Ø We are also interested inthe same analysis with a 99% confidence interval. Use the same steps exceptselect the Options button and changethe Confidence level: to 99.
Thanks, but please upload the full excel file, since the "hours of sleep a student" information is still missing.
You can use a free sharing site like http://www.mediafire.com/ to upload it and then post the sharing link here.
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 rollof the die. Then use this same formulato determine the average for all the remaining rows. In the next column to the right of that, type"median" after the "mean". Then in celly2 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 incells X22 and Y22, type in =AVERAGE(X2:X21) and the same for the Y column. Under those cells, type in =STDEV(X2:X21) andthe same for the Y column so that you have the mean and standard deviation forthe mean and of the median.
We then need to find the confidence interval for the SLEEPvariable. Under that column, in cellG22, type =AVERAGE(G2:G21). Under thatin cell G23, type =STDEV(G2:G21). Nowwe can find the maximum error of the confidence interval. In cell G24, type=CONFIDENCE.T(0.05,G23,20). The 0.05 is1 minus the confidence interval, the C23 is the standard deviation, and 20 isthe number in our sample. You then needto calculate the confidence interval from this maximum error by subtracting it from the mean and adding it to the meanas 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% confidenceinterval. Again, you would need to subtractthis 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 onpages 194 and 195 of the text
Question 3: this is from Minitab or Excel and is based onthe mean of the means
Question 4: this is from Minitab or Excel and is based onthe mean of the medians
Question 5: from Minitab or Excel
Question 6: You can look to page 68 in the text for someguidance on answering this question
Questions 7 and 8: from Minitab or Excel
Question 9: based on your understanding of confidenceintervals
Please visit a free sharing site like http://www.sendspace.com or http://www.wikisend.com and choose the excel file to upload. Once it's uploaded, paste the sharing/download link here in a reply to me.
Excellent, that's perfect. Give me about 30 minutes to solve all the questions.
Here you go:
Let me know if you have any questions.