Solution-Calculate the mean standard deviation

Calculate the mean standard deviation

Assignment Help Basic Computer Science

Reference no: EM132911188

In preparation for writing your report to senior management, conduct the following descriptive statistics analyses with Excel®.

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: EM132911188

Questions Cloud

Prepare adjusting journal entryfor consolidation worksheet : In relation to the above intragroup transactions prepare adjusting journal entries for the consolidation worksheet at 30 June 2020 and 30 June 2021

Transactional vs transformational leadership : Each member of your team should read at least 2 articles each on Transactional Vs Transformational Leadership.

What is your decision : Problem - Your employees have estimated the net present value of Project X to be $1.2 million. What is your decision

Diagnosing strategic performance symptoms : Diagnosing strategic performance symptoms and determining cure(s) for such issues is an organizational necessity.

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

Develop non-trivial state diagram : Develop a non-trivial state diagram (the diagram must feature at least four states) for at least one use-case or usecase scenario for your system.

What is the credit spread on? aaa-rated corporate? bonds : What is the credit spread on? AAA-rated corporate? bonds? How does the credit spread change with the bond? rating? What is credit spread on? B-rated corporate?

Determine the price of the share : The price of a company's share dropped by 3.00% by the end of the first year, down to $42.25. During the second year the price of the share dropped by $1.69.

Gathered throughout requirements determination : With a depth of information gathered throughout requirements determination (RD), the research team continues structuring requirements.

User Account

All Pages

Calculate the mean standard deviation

Reference no: EM132911188

Reference no: EM132911188

Questions Cloud

Reviews

Write a Review

Basic Computer Science Questions & Answers

Identifies the cost of computer

Input devices

Cores on computer systems

Prepare an annual budget in an excel spreadsheet

Write a research paper in relation to a software design

Describe the forest, domain, ou, and trust configuration

Construct a truth table for the boolean expression

Evaluate the cost of materials

The marie simulator

What is the main advantage of using master pages

Describe the three fundamental models of distributed systems

Distinguish between caching and buffering

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT