Statistical report assignment

Assignment Help Business Management
Reference no: EM132814338

Resource: Pastas R Us, Inc. Database

Apply: Statistical Report assignment.

In preparation for writing your report to senior management, conduct the following descriptive statistics analyses with Excel®. Answer the questions below in your Excel sheet or in a separate Word document:

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."

Calculate the mean, standard deviation, skew, 5-number summary, and interquartile range (IQR) for each of the variables.

Create a box-plot 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?

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?

What measure of central tendency is more appropriate to describe "Sales/SqFt"? Why?

Reference no: EM132814338

Questions Cloud

What are the resulting socioeconomic costs : Define a current problem in the selected country. What are the resulting socioeconomic costs of the problem to the affected individuals?
Discuss the issues organization face : Discuss the issues organization's face with regards to the protection of its customer information.
Performance management practices in manufacturing industry : Explain how the selected system and method are aligned with or different than performance management practices in the manufacturing industry.
Equal employment opportunity commission : Explore the Equal Employment Opportunity Commission (EEOC) website to learn more about this federal agency.
Statistical report assignment : 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."
Current management and leadership styles : Complete a SWOT Analysis where you identify Strengths, Weaknesses, Opportunities, and Threats associated with your current management and leadership styles.
Discuss process for developing project schedule : Discuss the process for developing a project schedule. How does this apply to a chosen organization?
Literature on leadership today describes sets of skills : Literature on leadership today describes sets of skills or traits that leaders should have, and actions that should be taken to be effective.
Disseminate this plan to entire company : Outline a plan for a team meeting with your managers and elaborate how together you will disseminate this plan to the entire company.

Reviews

Write a Review

Business Management Questions & Answers

  Focus on the success of an e-commerce organisation

Which metrics focus on the success of an e-commerce organisation (using websites, social media, mobile, other Web 2.0 applications)

  Web and the mass media approach

What is the difference between the personal contact model of communicating on the Web and the mass media approach?

  What are the depreciation tax shields in month

What are the depreciation tax shields in each month? What are the firm's free cash flows without the purchase of embroidery machine and with the purchase?

  Minimum daily revenue to keep the operation

What is the minimum daily revenue to keep the operation in the long-run? Please show step by step calculation, formulas, and explanations I can learn this topic

  Use balanced criteria for ethical decision making

Assuming you were in their position, discuss how you would address the problem to ensure that your final decision is fair and balanced, and explain why it is important to use balanced criteria for ethical decision making.

  Define information security

Define information security. Explain how computer security can protect data.

  Manipulate data within a program

One of the foundation skills in development is the use of variables to hold and manipulate data within a program

  Contribution to computer science

Write a 250-300 word description for each person stating who they are, what their contribution to Computer Science was, and why it was significant. Include at least 3 references for each person. Please use proper grammar and important content. (W..

  Manufactures components for products

The CFO of a company with global operations has a forecast that indicates that the euro will depreciate in value against the dollar by 30% over the next year.

  Avoiding conflict at all costsin most cases conflict is

avoiding conflict at all costsin most cases conflict is considered a negative factor that should be avoided at most any

  Do they already share all the etiquette and rules of game

Discuss whether it is fair for an international sports organization to require all athletes to speak the same verbal language.

  Asymmetric information and the credit market

Asymmetric Information and the Credit Market. Sean is a rice farmer. To grow rice, he must buy seeds, which cost $100. Rice production is risky.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd