cmgt6790

In preparation for writing your report to senior management next week, conduct the following descriptive statistics analyses with Microsoft® Excel®. Answer the questions below in your Microsoft® Excel® sheet.
Assignment Content
This assignment must be submitted as a Single Sheet Excel page!
In preparation for writing your report to senior management next week, conduct the following descriptive statistics analyses with Excel®. Answer the questions below in your Excel sheet:
1. Insert a new column in the database that corresponds to “Annual Sales.” Annual Sales is the result of multiplying a restaurant’s “SqFt.” by “Sales/SqFt.”
2. Calculate the mean, standard deviation, skew, and interquartile range (IQR) for each of the variables. (These should be at the bottom of the data set corresponding to each variable)
3. Create a boxplot for the “Annual Sales” variable. Does it look symmetric? Would you prefer the IQR instead of the standard deviation to describe this variable’s dispersion? Why?
4. Create a histogram for the “Sales/SqFt” variable. Is the distribution symmetric? If not, what is the skew? Are there any outliers? If so, which one(s)? What is the “SqFt” area of the outlier(s)? Is the outlier(s) smaller or larger than the average restaurant in the database? What can you conclude from this observation?
5. What measure of central tendency is more appropriate to describe “Sales/SqFt”? Why?
Note: To write the verbiages of your assignment, please use a single text box on the excel page and type your responses. Please see the example I attached below. If you have any questions, please ask not in a private message but in the course question section because my response to your question may help other students also.
infosys

Don't use plagiarized sources. Get Your Custom Essay on
cmgt6790
Just from $13/Page
Order Essay
Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.
error: Content is protected !!
Live Chat+1(978) 822-0999EmailWhatsApp

Order your essay today and save 20% with the discount code ORIGINAL