Calculating mean, median, and mode

 

 

 

 

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]?

 

Sample Solution

e roles women had in regards to civil participation was up and coming during Hilda Polachecks life. Prior to being well versed in the ways of American life, Hilda was under the impression that men had more power than women, and therefore should be treated better. In fact she had stated that, “my father had come to America, I kept saying to myself, because here in this wonderful country a man was free to say what he wanted, even if he was wrong.”. This idea as stated by the father she loved and trusted showed how America felt about women. Women were not supposed to speak out. Men could speak out, and they always had the benefit of the doubt. They were held with high regard in areas of politics and were given a voice. Although what her father had told her seemed great, she was young and did not realize that it was unjust that women would not have the same treatment. Hilda Polacheck, after experiencing America for herself, quickly changed her ways and believed fighting for women’s rights independently and collectively was what she wanted to stand for. A role model of hers, Jane Addams, had shown the capability women had in participating in the community. One incident where Jane Addams had showed the power women had in addressing public concerns was when she had called the attention of the health department to the unsanitary conditions present in Chicago. The department claimed it was under control, but with the backing of some businessmen she put in a bid to collect garbage. In some time she was appointed garbage inspector of the ward. Jane Addams, a woman, was given a role in the community after addressing pressing concerns. She took action where it was needed, and started to try and fix the community in which she lived. Another time a problem existed with public baths, Jane Addams decided she would somehow come up with a solution. Jane Addams wanted to show that people would use public bathing facilities if they were offered to them. However, the board had claimed people would not use the facilities and it would be a major waste of public funds. So after Jane Addams got proof that people used them by having 3 baths put into the Hull House Basement, the Board of Health decided to open the first public bathing facility in all of Chicago. In Miss Addam’s words ,“Our contention was justified by the immediate and overflowing use of the public baths”. After Hilda was introduced to Hull House she wanted to make a way for herself. Hull house had taught her what she needed, and after being an apprentice to the inspiring and determined Jane Addams, she soon became a woman who was determined to make her own way in the world. Hilda had taken many jobs over the course of her life, and although that sounds impressive it also meant she left many of them. One incident where Hilda had a problem with the treatment of employees, was during her time as a bill clerk. Her responsibility was to operate the billing machine, but she was not permitted to talk to the girl next to her. They were given notecards, in which the color of each card would mean different things. After some time working for the company, Hilda’s voice started showing the toll being mute at work had. In response

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.