Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Using Microsoft Excel And Access 2013 For Accounting

Authors: Glenn Owen

4th Edition

1305161858, 9781305161856

More Books

Students also viewed these Accounting questions

Question

Personal role: This consists of service to family and friends.

Answered: 1 week ago

Question

The role of life: It consists of your own service to yourself.

Answered: 1 week ago