Project 2 Jake’s Auto Services’ regional manager notices that the

Project 2

Jake’s Auto Services’ regional manager notices that the sale of two types of tires has been sluggish for the last few business cycles. Atlas tires and Continental tires brands are lagging compared to rivals such as Michelin that sell at a similar price point.

Directions

 1.  Use the following Excel workbook that prepares you to analyze the number-of-units-sold and total sales for the two tire brands (Atlas tires and Continental tires). Data are reported by two retail outlets within the region as aggregate totals and are organized by month, beginning with January, for a period of 12 months.
    *   Atlas Tires and Continental Tire Sale Excel File<https://drive.google.com/file/d/1vyKxB1qlfdBwgJpOBuqIBj_ytDxpxbNm/view?usp=sharing>
 2.  Create a chart or graph that enables a reader to visually contrast and compare the data. Make sure to select a graphic technique that clearly communicates the results. The final product should be easy to read, properly labeled, clearly captioned, and accurately inserted into the final report. Follow APA style for in-text references to exhibits.
 3.  Prepare a statistical analysis that includes the following:
    *   Calculate annual mean, median, and mode (if one exists) for each brand by store as well as for the region.
    *   Calculate annual range, quartiles, standard deviation, and coefficient of variation for each brand by store as well as for the region.
    *   Create a table that clearly denotes column and row headings for the calculated results. Properly insert the table into the managerial report. Follow APA style guidelines for in-text referencing of an exhibit.
 4.  Management has a specific interest in the Main Street location sale of Atlas tires. The provided data distribution is considered normal; therefore, use the store’s annual Atlas tire mean and standard deviation for your analysis. Determine the probability that on any one day the Main Street store would have:
    *   greater than 50 Atlas tires,
    *   fewer than 30 Atlas tires, and
    *   between 40 Atlas tires and 80 Atlas tires.

Place the results into context relative to the store’s overall Atlas tire sales when discussing sales performance.

 1.  Prepare a complete briefing that provides an objective analysis of your work.
    *   Part 1 of your report should be a “Results Section” that delivers simply an explanation of the mathematics (using tables and graphs) and how results were obtained.
    *   Part 2 of the report should consist of a “Discussion Section” of 250 to 350 words that interpret your results and details the meaning of your outcomes. The analysis must incorporate the illustrative information presented in your chart or graph by properly infusing numerical data in the discourse. Be sure to properly insert objects into the report using the proper APA in-text reference style. You must submit your Excel spreadsheet as background support. [MO2.2, MO2.3]?

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Assessment Description You are part of a surgical team and

Assessment Description You are part of a surgical team and your role is postoperative management of thoracic surgery. In your role, you are required to determine the course of action for the patient before you call surgeon. A right lower-lobe resection occurred due to adenocarcinoma. The nurse has called at

– You are being contracted as a financial consultant for

– You are being contracted as a financial consultant for a local  UNICEF organization . Your goal is to review the organizations financial statements and analyze their financial position from those statements. Using the tools and theories from this course, you will provide the organization with a sustainability plan for

Federal bureaucracy, its structure, and how it works

For the following assignment, you are asked to write about the concepts you have learned in Unit VII. At the beginning of the unit, you examined the federal bureaucracy, its structure, and how it works. Following that, you studied information about the judiciary, its structure, and how it works. In

Business Ethics – Week 3 Assignment Article Analysis Select two

  Business Ethics – Week 3 Assignment Article Analysis Select two peer-reviewed articles from the GU library on the topics for the current week. Analyze the articles separately and correlate them to your personal ethics assessment results. You are encouraged to share some specific examples of your assessment results to

AURORA CANNABIS INC.’S

AURORA CANNABIS INC.’S Stock Presentation Presentation Guidelines Be sure you have an introduction, an analysis and a conclusion even though this is a presentation and not a paper. Use APA in your Power Points and cite your sources and Wikipedia is still not a source. You need to compare and

When/how have you witnessed the Dunning-Kruger Effect occur in your

 When/how have you witnessed the Dunning-Kruger Effect occur in your own life?  What could we do to prevent this effect from occurring so frequently?  In your reply, don’t forget to reference something from the notes (e.g. for this question you could briefly describe the Dunning-Kruger Effect before answering the questions).  

Gun Control law(s)

Gun contol law(s), can be a single law of multiple reguarding gun control • The history of the law presented. • Explain the purpose of the law in the past. • Why the law was important back when it was enacted. • Explain whether the law is helpful to society.

Review Comments-1: 1. Detection of covid-19 using an infrared fever

Review Comments-1: 1. Detection of covid-19 using an infrared fever screening system (IFSS) based on deep learning technology is the proposed title of this paper. 2. Keyword should be start with capital letter. 3. How to detect the visual images? 4. Selection of ML should be justified by the author.

After learning about the High Middle Ages and the growth

  After learning about the High Middle Ages and the growth and progress of western society (Chapter 8 lecture), answer the following question. Follow the directions carefully in order to receive full credit.  Chapter 8 Lecture Question: In this lecture, we discussed the many positive developments that Europeans enjoyed beginning

Cultural Diversity (Eastern Europian)

Cultural characteristics: Communication patterns, spatial considerations, social organization, time considerations, locus on environmental control. Current health issues: life expectancy, common diseases conditions. Statements needs to be accurate, opinions to be adequately supported, sources to be identified and appropriately documented. Healthcare delivery issues: Acceptable/taboo behaviors for healthcare providers, role of family

Develop a 2- to 3-page role description for a graduate-level

Develop a 2- to 3-page role description for a graduate-level nurse to guide his/her participation on the implementation team where a new nursing documentation system is to be implemented. The role description should be based on the SDLC stages and tasks and should clearly define how this individual will participate

1. Compare and contrast the concepts of macro and micro

1.  Compare and contrast the concepts of macro and micro thinking as they relate to safety and health management in the workplace. Which is more in alignment with the safety management systems approach and why? (75 words) 2.  Explain the Five Why technique, and describe how this technique can be

In Weeks 1 and 2, our discussion focused on backward

  In Weeks 1 and 2, our discussion focused on backward design as a planning tool and the essential elements in a lesson plan. Now let’s look at the many instructional strategies that can be used to promote student learning. Respond to any of the following questions in a minimum

How to write an discussion from book? Briefly discuss the

How to write an discussion from book?    Briefly discuss the experiences of women, enslaved peoples, Native Americans and immigrants during the Jacksonian era.   Why were many Americans willing to exclude these groups from the new democratic system that emerged during the period?  Be specific; use at least two examples

Knowledge management.

This order is a case study report on a case study about knowledge management. Write a report which will address the following format: Cover Page To Include Case Study Title, Student Number, Date of Submission Contents Page Details of each key section of the report with page numbers on the

What are mobile forensics and do you believe that they

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Section IV: Conceptual Models and Grand Theories in the Unitary

  Section IV: Conceptual Models and Grand Theories in the Unitary Transformative Paradigm Section V: Grand Theories about Care or Caring Chapter 16: Margaret Newman’s Theory of Health as Expanding Consciousness Chapter 17: Madeleine Leininger’s Theory of Culture Care Diversity and Universality Chapter 18: Jean Watson’s Theory of Human Caring

Theoretical Foundations of ESL/EFL Reading Pedagogy

Description Summary of 10 Research Articles: Find and/or select 10 research articles related to Theoretical Foundations of ESL/EFL Reading Pedagogy. Write an annotated bibliography of the articles, including an introduction on the topic, your rationale for choosing the topic, a final conclusion generalizing your view of the findings of the