Here is your Question:
Lab question worth 30/100 points; partial credit is available.
Open Final Case 1 Excel file in the folder Cases on Moodle – find your data set and business case there. Save the file under the name “Final Exam_Your Name&Last Name”.
Do statistical analysis (shaw all your computing in Excel!) and answer all questions below:
- Describe your data set and case – 5 points
- Use the data set to construct a frequency histogram; describe the shape of the distribution – 5 points
- Use the Data Analysis ToolPack to compute the Descriptive Statistic Summary with the Confidence level for Mean 95 – 5 points
- Discuss the Summary output – 5 points
- Use the output to calculate a 95 present confidence interval for the population mean age estimate for all viewers of the ad – 5 points
- In conclusion, describe statistical methods and tools used, then answer the question: Remembering that the cigarette industry requires that the models must appear at least 25 years old, does the confidence interval make us 95% confident that the population mean perceived age estimates is at least 25? – 5 points
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."