Due: Due: In this project, you will be using data to calculate various statistical values such as: mean, median, mode, maximum, minimum, standard deviation and z-scores. You will compare the data to your personal information. You will also create tables and graphs to help analyze the data. You will be asked to reflect on your findings. In this project you are required to do the following:1. Download the Excel file with the MPG data. • Put your name, course name and project name on your spreadsheet• Use Excel to find the following statistics for the given data: Mean, median, mode, minimum, maximum, range, and Standard deviation of the MPG values. 2. Calculate the z-score of the mpg for your vehicle (or the vehicle that you are most commonly transported in).The MPG value can either be provided by the owner/operator of the vehicle, or obtained from https://www.fueleconomy.gov/feg/findacar.shtml or similar website.3. Create visual representations of the data. • Create a frequency distribution table for the type of vehicle. Excel’s ability to sort data will be useful for this, although you do not have to use Excel to determine the frequencies.• Create an appropriate graph of the type of vehicle.• Create a frequency distribution table of the frequency of mpg values for the data. To do this you must first determine what range of values to use for each class interval. Excel’s ability to sort data will be useful for this, although you do not have to use Excel to determine the frequencies.• Create theappropriate graph of the frequency of cars in the mpg value rangesfrom your frequency distribution table.Include appropriate labels on your graphs. 4. Write a reflection paper about your experience with this data project. Remember that we are looking for elegant and sophisticated reasoning. Include the following items:• Your name, course and name of the project. • Reflect on and analyze the values you found in your spreadsheet:o Quantify what types of vehicles were used by people in this survey. o Report on the statistical values found for this data; what information did you learn from the statistics on this data. Which value best represents the ‘average’ MPG for this data set?o How is the data distributed? Is it skewed? Explain. What does this tell you about the data? How is this reflected in your histogram?• Interpret the meaning of the z-score for your vehicle. Explain what the z-score for your value tells you about your personal fuel efficiency.• Explain your process for making the frequency tables and graphs. How/why did you decide to use your class-intervals? How/why did you determine what type of graph to use?• Explain the advantage(s) of creating frequency tables and graphs of the data over leaving the data in the original form.• Reflect on the results of your project. What did you learn by doing this project? How might Excel help you analyze data or calculatestatistics in the future?In addition to the above instructions, your project should:• Be well organized and easy to follow.• Have clearly labeled columns and statistics. • Have titles and labels on graphs.• The paper should be in paragraph form (not just bulleted answers!).• Be clear to someone who is not familiar with the project. • Provide support for your statements e.g. explain how values were found.• Give specific values (i. e. quantify statements).• Use appropriate representations (tables, color, formatting) that help the reader understand the project.• Project should be your original work, copying someone else’s work is cheating, sharing your work with someone else is cheating.
Follow your instructor’s directions for turning in this project. MPG Car Type 26.4 car 23.8 car 31.5 car 30.0 car 25.8 car 24.2 car 26.4 car 24.0 car 24.9 car 22.0 car 22.1 car 23.0 car 24.0 car 18.0 car 18.0 car 24.0 van 12.6 van 21.0 van 23.0 suv 13.0 suv 20.1 suv 16.5 suv 21.0 suv 26.2 car 23.0 car 33.4 car 25.0 car 24.0 car 21.1 suv 14.0 suv 14.8 suv 14.9 suv 36.0 van 64.0 van 23.0 van 22.0 van 21.0 van 24.3 van 24.0 van 22.0 van 22.0 van 23.9 van 24.0 van 34.0 van 22.0 van 33.8 van 23.4 van 23.0 van 21.0 truck 18.0 truck 17.2 truck 17.0 truck 21.7 truck 18.0 truck 25.0 car 21.0 car 14.7 truck 16.4 suv 13.0 suv 11.8 suv 14.5 suv 16.0 suv 21.0 suv 14.7 suv 14.0 truck 12.0 truck 16.6 truck 17.0 truck 13.2 truck 12.0 truck 14.8 truck 14.9 truck 17.0 truck 14.5 truck 16.5 suv 21.0 car 23.0 car 16.7 suv 21.2 suv 16.8 suv 20.0 suv 24.0 suv 16.9 suv 12.4 truck 13.4 truck 14.8 truck 12.7 truck 12.0 truck 13.8 truck 14.5 truck 41.0 motorcycle 62.5 motorcycle 61.0 motorcycle 44.4 motorcycle 43.0 motorcycle 44.0 motorcycle 25.0 car 25.0 car 18.0 suv 18.0 truck 18.0 suv 25.0 car 27.0 car 18.0 truck 18.0 truck 35.0 car 17.0 suv 21.0 suv 26.4 van 27.0 van 34.0 van 31.0 van 26.0 van 26.0 van 28.7 van 38.0 motorcycle 39.0 motorcycle 32.0 motorcycle 25.0 car 12.0 truck 15.0 truck 27.0 suv 22.0 suv 19.0 suv 20.0 suv 16.7 suv 12.0 suv 18.2 suv 18.0 suv 14.6 suv 24.0 car 20.1 car 20.4 suv 15.0 suv 17.0 suv 15.5 suv 18.0 suv 17.0 suv 20.1 suv 20.0 suv 17.0 suv 29.0 car 27.0 car 31.0 van 20.4 van 31.0 van 32.4 van 26.7 van 25.0 van 24.6 van 17.0 suv 17.0 suv 19.8 suv 18.0 suv 26.0 van 26.7 van 27.0 van 28.0 van 25.4 van 25.0 suv 23.8 suv 33.8 suv 25.0 suv 34.0 car 23.0 suv 38.0 motorcycle 42.0 motorcycle 32.4 motorcycle 36.0 motorcycle 25.0 car 27.6 car 25.0 car 27.0 car 20.0 suv 22.0 suv 18.5 suv 13.7 suv 20.0 suv 17.0 suv 33.5 car 27.0 van 31.0 van 33.9 van 26.0 van 32.0 car 33.8 car 27.0 car 29.0 car 31.0 car 34.1 car 26.0 car 26.0 car 32.0 car 30.0 car 33.0 car 34.5 car 37.0 car 35.0 car 14.9 suv 18.0 suv 20.0 truck 20.0 truck 22.0 truck 16.5 truck 19.0 truck 17.6 truck 20.0 truck 29.4 car 26.0 car 29.0 car 29.0 car 24.0 car 43.4 car 29.0 car 26.0 car 28.8 car 24.6 car 22.4 car 23.1 car 23.0 car 24.0 car 44.0 motorcycle 41.2 motorcycle 28.6 motorcycle 32.8 motorcycle 35.4 motorcycle 34.0 motorcycle 30.4 van 29.0 van 28.0 van 28.7 van 26.0 van 26.0 van 26.0 van 32.9 car 14.2 truck 23.0 car 34.2 car 25.0 suv 20.5 car 25.4 car 31.8 car 12.4 truck 45.0 motorcycle 24.0 car 17.0 truck 21.0 car 16.0 suv 28.0 car 17.8 car