Corresponds to Annual Sales

Assignment Help Business Management

Reference no: EM132765591

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 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?

Attachment:- Pastas R Us.rar

Reference no: EM132765591

Questions Cloud

How much premium will a have to pay out : Amy Ltd is currently valued at $50 in the market. A potential acquirer A believes that it can add value in two ways: $15 of value can be added through better.

Describe the role of photosynthetic organisms : Describe the role of photosynthetic organisms, such as plants, in converting the energy of light to energy that can be used by all living things including the p

Offspring in a cross between the two guinea pigs : What will most likely be the phenotypes of the offspring in a cross between the two guinea pigs? Explain your answer

What would his overtime rate be : Question - Gilberto earns $13.00 per hour. He would earn time and half if he worked over 40 hours. What would his overtime rate be

Corresponds to Annual Sales : 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."

Which form of business organization puts the least risk : The partnership generated net income of P51,600 in 20x4. According to the partnership contract, Jaimie, Kristine and LAlly share profit and loss equally.

How might the information from a species population : How might the information from a species population decline map across the globe be used to prevent species extinctions?

What is the maximum unit purchasing price : What is the maximum unit purchasing price that makes purchasing a beneficial decision in comparison to making

Identify the as physical or chemical properties : Identify the following as physical or chemical properties.

User Account

All Pages