Senior management, Insert a new column in the database that

Senior management

Assignment Help Basic Computer Science

Reference no: EM133069231

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:

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?

Reference no: EM133069231

Questions Cloud

Buying process in organizations : How the seller plans to influence the buyer during each of the eight steps Who is involved in the purchase decision within the buyer's "buying center"

Strategies-goals and sensitivities of the customer : Consider your favorite product and discuss the strategies, goals, and sensitivities of the customer from both the B2B and B2C perspectives.

Creating an effective presentation : Presentation skills are essential in business. This assignment focuses on creating an effective presentation

Define what information silo : Define what an information silo is. Explain why information silos are a problem for organizations. Discuss why organizations are moving to the cloud.

Senior management : 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."

Risk management plan : Introduction that states the purpose of the paper as part of the risk management plan.

Awareness of organization security measurements : Present employee training recommendations for creating awareness of the organization's security measurements.

Discuss defensive programming : Discuss Defensive Programming and whether or not you would use it when developing procedures, processes, and architectures that guide work execution

How social media can help your business : Social media is online communication that allows you to communicate with your customers in real-time.

User Account

All Pages