Database corresponding to annual sales

Assignment Help Business Management
Reference no: EM133200287

Statistics Analysis

In preparation for writing your report to senior management next week, conduct the following descriptive statistics analyses with Microsoft® Excel®. Answer the questions below in your Microsoft® Excel® sheet or a separate Microsoft® Word document:

Pastas R Us, Inc. Database

  • Insert a new column in the database corresponding to "Annual Sales." Annual Sales result from multiplying a restaurant's "SqFt." by "Sales/SqFt."
  • Calculate each variable's mean, standard deviation, skew, 5-number summary, and interquartile range (IQR).
  • Create box plot for the "Annual Sales" variable. Does it look symmetric? Would you prefer the IQR to describe this variable's dispersion instead of the standard deviation? Why?
  • Create  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: EM133200287

Questions Cloud

Magazine article on social media and the law : BUS 242 Northern Virginia Community College - current newspaper, online post or blog, or magazine article on social media and the law. Write one paragraph
Write a daycare handbook for the parents : Need someone to write a daycare handbook for the parents. It need to have a philosophy, missions, rules, dress code for the kids, holiday
Analyze how the organization developed its brand equity : OMM 615 ashford university. Analyze how the organization developed its brand equity. Assess the influence of branding on an organization's IMC.
Genetic presentation-genetic disorder to research : You must choose a genetic disorder to research. No two students may choose the same topic. Chromosome and How it is Affected (Ex: Chromosome #7 Deletion)
Database corresponding to annual sales : In preparation for writing your report to senior management next week, conduct the following descriptive statistics analyses with Microsoft® Excel®.
Research on terms - confrontation and dependency : Pick any one of the following terms for your research: authority, competition, confrontation, dependency, empowerment, intergroup conflict
Explain why people fall victim to this type of fraud : Colorado Technical University - Describe how the scam was conducted and outline its characteristics and Explain why people fall victim to this type of fraud
Describe what you think the companys values are : Describe what you think the company's values are. Which departments might have to expand rapidly based on exponential success over the Internet?
What steps could have been taken to avoid the ethical blowup : Think about the Enron video that you watched in this course. In your opinion, what steps could have been taken to avoid the ethical blowup

Reviews

Write a Review

Business Management Questions & Answers

  Bottom of the chart

Visit www.goldprices.com and use the chart to find the very latest price of gold. Compare that price to the price at the beginning of the day. Next, select "1 year" at the bottom of the chart.

  Description of the strategic moves

Select 5 strategic moves Amazon could undertake to solve a number of its strategic concerns. Make sure the strategic moves are consistent with the firms overal

  How they like to interact with the company and the ability

How they like to interact with the company and the ability to deliver personalised experiences which they find useful and engaging. Why?

  Modern businesses are greatly impacted by teams

Modern businesses are greatly impacted by teams and group work. Many managers believe that decisions made by a group will be superior to decisions made by an in

  From a view of marketing business domain

From a view of marketing business domain, how is positioning map formulated?

  What are your reactions to the given idea

What are your reactions to the idea that leadership is not about people, but the spaces between people in human interaction?

  Why is it necessary for a company to protect itself

Select four or five suggestions that you could make to your boss in regard to protecting an employer. Why is it necessary for a company to protect itself?

  Advantage in the e-commerce environment

Will core competency of strategic business units be enough to maintain a competitive advantage in the e-commerce environment?

  Non-profit vs a for-profit organization

Making note of the differences and similarities between a non-profit vs a for-profit organization, i.e. the user experience

  What is profit from the transaction

What is your profit from the following transaction (note per share costs quoted). Profit is how much you made or how much you didn't lose.

  Differentiate among paid-owned and earned media

1. Differentiate among paid, owned, and earned media. Give a specific example of each of the following types of media for Coca-Cola:

  Communication is important to team development and cohesion

Communication is important to team development and cohesion. It is how organizations share information, ideas, and expectations

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd