Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

EXCEL Work. Submit in xlsx Select a particular model of car and perform some descriptive statistics regarding its annual per unit sales over (at least) the last five calendar years XXXXXXXXXXList the...

1 answer below »

EXCEL Work. Submit in xlsx

Select a particular model of car and perform some descriptive statistics regarding its annual per unit sales over (at least) the last five calendar years XXXXXXXXXXList the sales (unit sales) by year and the source of the information. No credit for this case will be given without the data source provided. Then, calculate the population standard deviation of those sales by year, calculate the mean sales of the data set, calculate the median sales of the data set, and draw a box and whiskers diagram of the data set.

Use the Data Analysis ToolPak to generate these descriptive statistics.

Provide supporting calculations ******

Select a second model of car, list its per unit sales for the same (at least) five-year period and calculate its descriptive statistics. Indicate the source for your information. Draw a box and Whiskers’ graph for the second car. Then compare the standard deviations of the two cars and write a conclusion as to which car, if this history is a good predictor of future performance next year, is riskier based on your analysis.

Answered 1 days After Jun 22, 2022

Solution

Sathishkumar answered on Jun 23 2022
97 Votes
Car_sales
    Manufacturer    Model    Sales_in_thousands    __year_resale_value    Vehicle_type    Price_in_thousands    Engine_size    Horsepower    Wheelbase    Width    Length    Cu
_weight    Fuel_capacity    Fuel_efficiency    Latest_Launch    Power_perf_facto
    Acura    Integra    16.919    16.36    Passenger    21.5    1.8    140    101.2    67.3    172.4    2.639    13.2    28    2/2/12    58.28014952
    Acura    TL    39.384    19.875    Passenger    28.4    3.2    225    108.1    70.3    192.9    3.517    17.2    25    3/6/11    91.37077766
    Acura    CL    14.114    18.225    Passenger        3.2    225    106.9    70.6    192    3.47    17.2    26    4/1/12
    Acura    RL    8.588    29.725    Passenger    42    3.5    210    114.6    71.4    196.6    3.85    18    22    10/3/11    91.38977933
    Audi    A4    20.397    22.255    Passenger    23.99    1.8    150    102.6    68.2    178    2.998    16.4    27    8/10/11    62.7776392
    Audi    A6    18.78    23.555    Passenger    33.95    2.8    200    108.7    76.1    192    3.561    18.5    22    9/8/11    84.56510502
    Audi    A8    1.38    39    Passenger    62    4.2    310    113    74    198.2    3.902    23.7    21    2/27/2012    134.6568582
    BMW    323i    19.747        Passenger    26.99    2.5    170    107.3    68.4    176    3.179    16.6    26    6/28/2011    71.19120671
    BMW    328i    9.231    28.675    Passenger    33.4    2.8    193    107.3    68.5    176    3.197    16.6    24    1/29/2012    81.87706856
    BMW    528i    17.527    36.125    Passenger    38.9    2.8    193    111.4    70.9    188    3.472    18.5    25    4/4/11    83.9987238
    Buick    Century    91.561    12.475    Passenger    21.975    3.1    175    109    72.7    194.6    3.368    17.5    25    2/11/11    71.18145132
    Buick    Regal    39.35    13.74    Passenger    25.3    3.8    240    109    72.7    196.2    3.543    17.5    23    3/9/11    95.63670253
    Buick    Park Avenue    27.851    20.19    Passenger    31.965    3.8    205    113.8    74.7    206.8    3.778    18.5    24    3/23/2012    85.82840825
    Buick    LeSa
e    83.257    13.36    Passenger    27.885    3.8    205    112.2    73.5    200    3.591    17.5    25    7/23/2011    84.25452581
    Cadillac    DeVille    63.729    22.525    Passenger    39.895    4.6    275    115.3    74.5    207.2    3.978    18.5    22    2/23/2012    113.8545976
    Cadillac    Seville    15.943    27.1    Passenger    44.475    4.6    275    112.2    75    201        18.5    22    4/29/2011    115.6213578
    Cadillac    Eldorado    6.536    25.725    Passenger    39.665    4.6    275    108    75.5    200.6    3.843    19    22    11/27/2011    113.7658739
    Cadillac    Catera    11.185    18.225    Passenger    31.01    3    200    107.4    70.3    194.8    3.77    18    22    9/28/2011    83.48309358
    Cadillac    Escalade    14.785        Car    46.225    5.7    255    117.5    77    201.2    5.572    30    15    4/17/2012    109.5091165
    Chevrolet    Cavalier    145.519    9.25    Passenger    13.26    2.2    115    104.1    67.9    180.9    2.676    14.3    27    8/17/2011    46.36334747
    Chevrolet    Malibu    135.126    11.225    Passenger    16.535    3.1    170    107    69.4    190.4    3.051    15    25    3/19/2012    67.31446216
    Chevrolet    Lumina    24.629    10.31    Passenger    18.89    3.1    175    107.5    72.5    200.9    3.33    16.6    25    5/24/2011    69.9913956
    Chevrolet    Monte Carlo    42.593    11.525    Passenger    19.39    3.4    180    110.5    72.7    197.9    3.34    17    27    12/22/2011    72.03091719
    Chevrolet    Camaro    26.402    13.025    Passenger    24.34    3.8    200    101.1    74.1    193.2    3.5    16.8    25    10/23/2011    81.11854333
    Chevrolet    Corvette    17.947    36.225    Passenger    45.705    5.7    345    104.5    73.6    179.7    3.21    19.1    22    12/5/12    141.14115
    Chevrolet    Prizm    32.299    9.125    Passenger    13.96    1.8    120    97.1    66.7    174.3    2.398    13.2    33    11/9/11    48.2976361
    Chevrolet    Metro    21.855    5.16    Passenger    9.235    1    55    93.1    62.6    149.4    1.895    10.3    45    4/13/2012    23.27627233
    Chevrolet    Impala    107.995        Passenger    18.89    3.4    180    110.5    73    200    3.389    17    27    6/18/2011    71.83803944
    Chrysler    Se
ing Coupe    7.854    12.36    Passenger    19.84    2.5    163    103.7    69.7    190.9    2.967    15.9    24    1/16/2012    65.95718396
    Chrysler    Se
ing Conv.    32.775    14.18    Passenger    24.495    2.5    168    106    69.2    193    3.332    16    24    11/17/2011    69.52135505
    Chrysler    Concorde    31.148    13.725    Passenger    22.245    2.7    200    113    74.4    209.1    3.452    17    26    6/6/12    80.02378204
    Chrysler    Ci
us    32.306    12.64    Passenger    16.48    2    132    108    71    186    2.911    16    27    6/10/11    53.56619987
    Chrysler    LHS    13.462    17.325    Passenger    28.34    3.5    253    113    74.4    207.7    3.564    17    23    8/5/12    101.3292807
    Chrysler    Town & Country    53.48    19.54    Car                                        7/13/2011
    Chrysler    300M    30.696        Passenger    29.185    3.5    253    113    74.4    197.8    3.567    17    23    10/2/12    101.6552441
    Dodge    Neon    76.034    7.75    Passenger    12.64    2    132    105    74.4    174.4    2.567    12.5    29    12/12/11    52.08489875
    Dodge    Avenger    4.734    12.545    Passenger    19.045    2.5    163    103.7    69.1    190.2    2.879    15.9    24    1/7/12    65.65050834
    Dodge    Stratus    71.186    10.185    Passenger    20.23    2.5    168    108    71    186    3.058    16    24    10/31/2011    67.87610784
    Dodge    Intrepid    88.028    12.275    Passenger    22.505    2.7    202    113    74.7    203.7    3.489    17        2/6/12    80.83147017
    Dodge    Viper    0.916    58.47    Passenger    69.725    8    450    96.2    75.7    176.7    3.375    19    16    7/8/11    188.144323
    Dodge    Ram Pickup    227.061    15.06    Car    19.46    5.2    230    138.7    79.3    224.2    4.47    26    17    6/3/12    90.21170005
    Dodge    Ram Wagon    16.767    15.51    Car    21.315    3.9    175    109.6    78.8    192.6    4.245    32    15    6/1/12    71.13529161
    Dodge    Ram...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Attach File