Calculate the mean-standard deviation

Assignment Help Business Management

Reference no: EM133141151

Review - Apply: Statistical Report assignment.

Conduct the following descriptive statistics analyses with Microsoft® Excel®. Answer the questions below in your Microsoft® Excel® sheet or in a separate Microsoft® 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: EM133141151

Questions Cloud

Potential impact of brexit on british and global economy : Analyze the potential impact of Brexit on the British and Global Economy.

Describe what does it mean sales organization : Could you please describe what does it mean a "Sales Organization"? What are the main elements of a Sales Organization?

Critical step in event planning process : Creating a SWOT analysis is a critical step in the event planning process, whether the event stays in one place, or changes location.

Marketing plan and budget : Write the marketing plan and sales strategy section of your business plan, in which you. Assess your chosen company's market competition.

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

Identify common characteristics of organization : Identify common characteristics of each organization. Describe the key issues that affected the merger plan and its implementation.

Decision-making authority distributed in organization : How is decision-making authority distributed in this organization? Is this the most efficient method of decision-making in this instance? Why or why not?

Utilizing the tools of strategic planning : Compare and contrast three companies' mission/vision/values statements, utilizing the tools of strategic planning.

Acquisitions and strategic alliances strategies : How the corporate headquarters creates value by implementing mergers/acquisitions and strategic alliances strategies.

User Account

All Pages