Question: WK2DQ1 Document 30 random responses: Use Excel formule -RANDBETWEEN(0,7). Each response represents the number of times each person has dined out in the past week.

 WK2DQ1 Document 30 random responses: Use Excel formule -RANDBETWEEN(0,7). Each response

WK2DQ1 Document 30 random responses: Use Excel formule -RANDBETWEEN(0,7). Each response represents the number of times each person has dined out in the past week. Include the data set and your output in your response. Conduct a descriptive statistics (use Excel add-in Analysis Toolkit) and box plot on all 30 responses. Comment on the shape of the distribution. Is it the shape you would expect? Why or why not? (Refer to Chapter 3 Review: Supplementary Exercises 62 in the textbook). In replies to peers. discuss whether you agree or disagree and justify your answer. To be honest, I struggled with the box plot. It took me a while to figure it out. I knew the data was random, so I had no expectations going into the assignment. The mean, median, and mode wasn't surprising because the range is very limited. So, a mean of 3.6 is pretty spot on in the middle. The mode was lower than I expected, given that it was a 2. The median made sense at 3, I expected 3-4 in that data point. I think the kurtosis was could have gone + or - either way, especially in a random data set. I'm glad I struggled with the excel assignment. I feel like I learn more when I struggle. I found out that I needed to download a feature to fulfill the box plot portion

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!