Question: Assignment 1 Quantitative Methods The data for the exercises below are provided in the Excel Worksheet (Assignment 1). Please create a Microsoft Word file with

  • Assignment 1

    Quantitative Methods

    The data for the exercises below are provided in the Excel Worksheet (Assignment 1). Please create a Microsoft Word file with the answers to the questions below. You can copy tables, formulas, graphs etc from your Excel worksheet onto the Word document for answering the assignment questions.

    The following questions are related to the worksheet named “JDPower”
    TextDescription automatically generated with medium confidence


  • The following scenario is related to the worksheet named “JeepSales”.

    TextDescription automatically generated

     
    • Construct percent bar charts of 
    1. Jeep sales 2011
    2. Jeep sales in 2006

    Compare the charts and write a short report supporting the owner’s position that in 2011, Liberty sales were still an important part of sales at the dealership.

  • J. D. Power Initial Quality Study of 2014 Automobiles




    CompanyCountry of OriginOverall Quality MechanicalOverall Quality Design
    AcuraJapan33
    AudiGermany43
    BMWGermany43
    BuickUnited States43
    CadillacUnited States43
    ChevroletUnited States33
    ChryslerUnited States34
    DodgeUnited States23
    FiatItaly22
    FordUnited States33
    GMCUnited States33
    HondaJapan33
    HyundaiKorea44
    InfinitiJapan33
    JaguarGreat Britain35
    JeepUnited States23
    KiaKorea33
    Land RoverGreat Britain23
    LexusJapan53
    LincolnUnited States43
    MazdaJapan32
    Mercedes-BenzGermany33
    MINIGreat Britain42
    MitsubishiJapan23
    NissanJapan33
    PorscheGermany45
    RamUnited States24
    ScionJapan33
    SubaruJapan32
    ToyotaJapan43
    VolkswagenGermany33
    VolvoSweden33
     
    Scoring Legend
    5 = Among the best
    4 = Better than most
    3 = About average
    2 = The rest


     
     


Develop a frequency distribution of the overall mechanical quality ratings. Describe the distribution. DS JDPower Develop a relative frequency distribution of the overall design quality ratings. Describe the distribution. DS JDPower Construct a percentage bar chart of the overall mechanical quality ratings for each of the following: automobiles of United States origin; automobiles of Pacific Rim origin (Japan/Korea); and automobiles of European origin (Germany/Italy/Great Britain/Sweden). Compare the three distributions in a written report. DS JDPower Construct a percentage pie chart of the overall design quality ratings for each of the following: automobiles of United States origin; automobiles of Pacific Rim origin (Japan/Korea); and automobiles of European origin (Germany/Italy/Great Britain/Sweden). Compare the three distributions in a written report. DS JDPower

Step by Step Solution

★★★★★

3.53 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Construct the bar chart for the data r... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

write your resume. Save it as a Microsoft Word file or .pdf file for submission. Be thoughtful about the resume organization that you selected and shared in the discussion for this unit. Follow the...

Q:

Interview an HR manager and write a short report on The Strategic Roles of the HR Manager at XYZ Company.

Q:

Research and write a short report (maximum of two typed pages) on green facility design making sure that you incorporate some of the key topics in this chapter.

Q:

3.38 The accompanying table gives data from a survey of new car owners conducted by J.D. Power and Associates (USA Today, June 16 and July 17, 2010). For each brand of car sold in the United States,...

Q:

When planning for construction of a parkway, engineers must consider the weights of cars to be sure that the road surface is strong enough. A simple random sample of 32 cars yields a mean of 3605.3...

Q:

Using the dataset below, answer the following questions. a ) Perform a descriptive analysis of this variable by calculating the measures of central tendency seen in the course. b ) Perform a...

Q:

View the 2013 Annual Reports for the Coca-Cola Company and PepsiCo, Inc., both linked here as well as on the Course Information page. Using these reports, answer the following questions: What are the...

Q:

View the 2013 Annual Reports for the Coca-Cola Company and PepsiCo, Inc., Using these reports, answer the following questions: What are the primary lines of business of these two companies, as shown...

Q:

This file contains two data sheets: 1. The Campus Crime Data for Minnesota (2009-2011) page provides actual data generated by the U.S. Department of Education's Campus Safety and Security Data...

Q:

1-1Complete the following problems and submit the results in either a Microsoft Word document or a Microsoft Excel spreadsheet. If you choose to use an Excel spreadsheet, place each problem on a...

Q:

You are given the following information about a hypothetical economy; C = 800 + 0.75Y I = 500 G = 900 Where C = Consumption I = Investment G = Government spending (i) Compute the equilibrium level of...

Q:

Using the cognitive model and the BRUSO model discussed in class, write survey items for the following general questions. It may take more than one question. Responding to a survey item is itself a...

Q:

Read the following text carefully, then answer the question. Exciting New Gym Opening Soon!!! Northside Gym is opening soon, providing a new level of gym experience. The gym will meet all your...

Q:

Complete the self-scoring "Followership Questionnaire" in Ch. 13 (p. 487) of Leadership: Theory and Practice . DueThursday respond to the following: Based on your results from the "Followership...

Q:

Research by Ericsson and other suggests that about 10,000 hours of deliberate practice are required to become an expert. What is required for deliberate practice? Group of answer choices Focused...

Q:

International clothier Gap, Inc. is proud of its Code of Business Conduct that urges all those associated with the company to participate in "Doing the Right Thing." The business, founded in 1969,...

Q:

Kellerman Company purchased a building and land with a fair market value of $525, 000 (building, $300, 000 and land, $225, 000) on January 1, 2016. Kellerman signed a 15-year, 10% mortgage payable....

Q:

Four GWU students have been selected to taste food sold by 3 different food trucks labeled as food truck A, B and C on H & 22nd Streets every Monday for 3-weeks. For each student, food trucks are...

Q:

A sample of 20 financial analysts was asked to provide forecasts of earnings per share of a corporation for next year. The results are summarized in the following table: Forecast ($ per share) Number...

Q:

The following model was fitted to observations from 1972 to 1979 in an attempt to explain oil-pricing behavior: Where y` = difference between price in the current year and price in the previous year,...

Q:

In a study to estimate the effects of smoking on routine health risk, employees were classified as continuous smokers, recent ex-smokers, long-term ex-smokers, and those who never smoked. Samples of...

Q:

According to Sperling, what is the capacity of iconic memory? a. Everything that can be perceived in a lifetime. b. Everything that can be heard in 1 minute. c. Everything that can be sensed in 1...

Q:

For information to travel from either the iconic or echoic sensory system to short-term memory, it must first be _______ and then encoded primarily into _______ form. a. selectively attended to;...

Q:

Collin is asked to repeat what his mother just told him. He says he forgot, but in reality Collin wasnt paying attention to his mother at all. This is an example of the ____________ explanation of...