Calculate mean-standard deviation-skew-interquartile range

Assignment Help Basic Computer Science

Reference no: EM133052933

Assignment

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?

Reference no: EM133052933

Questions Cloud

About internet of things and smart devices : In this unit, you learned about the Internet of Things and smart devices.

How switching to more dynamic database : Describes how switching to a more dynamic database will give eHermes a competitive advantage?

Implementing erp system : Would you consider implementing an ERP system or would you continue to use applications like MS Office to manage your business processes?

Discuss why implementation of erp system : Discuss why the implementation of an ERP system might require business process reengineering for Colony Nursery and Landscaping.

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

Millennia HealthCenter : You are on the same project team for the new IT system for the Millennia HealthCenter (MHC) that you were on for Project One and Project Two.

Differences between access and excel : Describe Microsoft Access and its components. Distinguish key differences between ACCESS and EXCEL.

About system requirements and implementation planning : Another term has almost come to an end. As you completed the modules, you learned about system requirements and implementation planning.

What is GIS database design : What is GIS database design? What is GIS application development?

User Account

All Pages