Solution-Calculate the mean-standard deviation

Calculate the mean-standard deviation

Assignment Help Basic Computer Science

Reference no: EM133058679

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?

Reference no: EM133058679

Questions Cloud

Five laws of cybersecurity : What topic was most interesting to you? Is there a topic you'd like to learn more about? Why? What did you learn ?

Different types of security measures : Describe at least five different types of security measures and include the components of each security measure.

Satisfying the requirement of data collection : Why are the traditional methods insufficient in satisfying the requirement of data collection?

Data protection responsibilities : You will prepare a RACI matrix that outlines roles of key players in the organization who have data protection responsibilities

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

Develop sequence diagrams for two use-case scenarios : Extend your class diagram by including associations, indicating the object role and multiplicity on each end of your associations.

Evaluate the history of cryptography : Evaluate the history of cryptography from its origins. Analyze how cryptography was used and describe how it grew within history.

Effectiveness and ease of use of aes : Based on your understanding of how AES was chosen, what is your opinion of the criteria used? What do you think about the effectiveness and ease of use of AES?

History of cryptography from origins : In the initial milestone writing assignment, you will evaluate the history of cryptography from its origins.

User Account

All Pages

Calculate the mean-standard deviation

Reference no: EM133058679

Reference no: EM133058679

Questions Cloud

Reviews

Write a Review

Basic Computer Science Questions & Answers

Computers and word processing applications

Importance of stakeholder engagement in policy making

Different types of execute support systems

How text mining is used in knowledge management

Consumption of natural resources by developed countries

Enterprise systems and data management

Analysis of various tools useful in policy making

What does access control lists mean

Relationship between database and information system

How does one assign probabilities to the marketing list

Describe how customer service programs provide employees

What are the causes of unemployment

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT