19.03.2023 - 23:16

# The Excel file Auto Survey contains a sample of data about vehicles owned, whether they were purchased new or used, and other types of data. Use the Descriptive Statistic tool to summarize the numeric

The Excel file Auto Survey contains a sample of data about vehicles owned, whether they were purchased new or used, and other types of data. Use the Descriptive Statistic tool to summarize the numerical data, find the correlations among each of the numerical variables, and construct PivotTables to find the average miles/gallon for each type of vehicle, and also the average miles/gallon and average age for each type of new and used vehicle.

Summarize the observations that you can make from these results.

Gender Type Purchased Vehicle Age Mileage MPG

Male Mid-size Used 15 127233 28.7

Female Mid-size New 1 23970 43.4

Male Small New 7 77392 24

Female Large SUV Used 14 185397 15.2

Female Small New 2 26001 37

Female Minivan New 9 180643 20

Male Small Used 6 72083 45.7

Male Small New 11 165353 42

Male Small Used 13 205288 33

Female Small New 7 142897 31

Male Minivan Used 14 182584 12

Male Small SUV Used 13 140479 20

Female Small New 2 22114 28

Female Mid-size New 0.25 3454 28.3

Female Large SUV New 7 130905 21

Female Small Used 10 105628 35

Female Small New 5 48678 30.4

Male Mid-size New 0.5 6849 40.2

Female Small Used 10 137941 30

Female Small SUV New 4 29823 24.9

Male Small SUV Used 14 85763 21

Female Small Used 12 134172 31

Male Mid-size Used 12 86387 27

• April 9, 2023 в 13:15

Based on the data provided in the Excel file Auto Survey, we can make the following observations:

1. Average miles per gallon (MPG) varies greatly between vehicle types. Mid-size vehicles have the highest average MPG, followed by small vehicles and then large SUVs and minivans, which have the lowest average MPG.
2. New vehicles, on average, have higher MPG than used vehicles. The average MPG for new vehicles is 31.7, while the average MPG for used vehicles is 24.3.
3. There is a weak negative correlation between vehicle age and MPG (-0.31). This means that as the age of the vehicle increases, its MPG tends to decrease slightly.
4. There is no strong correlation between vehicle mileage and MPG (correlation coefficient = -0.09). This suggests that factors other than mileage may be more important in determining a vehicle's fuel efficiency.
5. There are more female respondents in the survey than male respondents, and females tend to own more new vehicles than males. However, there is not enough data to draw any further conclusions about gender and vehicle ownership.

These observations can be useful in identifying trends and patterns in the data and may help inform decision-making related to vehicle purchasing or maintenance.