Eastern Oregon University Auto MPG Data Excel Worksheet


I nonproduction an exposition for this Vocation doubt to succor me examine.

fundamental aptitude in vocation grounds dissection is generating and presenting described statistics. Luckily for you, MS Excel has all the tools you nonproduction. For this assignment, you are to download a quotation improve, purport the improve into Excel, use Excel to produce convenient proneness and division measures, and decipher those measures. You earn be using grounds for gas mileage in cars.

Instructions:

  1. Download the subjoined two improves: auto-mpg-names.txt and auto-mpg-data.txt. The foremost improve provides a patronymic of the grounds and the prevent is the grounds set itself.
  2. Import the auto-mpg-grounds improve into Excel. For a refresher on purporting this improve, see the subjoined:
  3. Calculate and decipher convenient proneness measures (i.e., medium, median and edict) for the subjoined variables: mpg, demolition, horsepower, ponderosity, and acceleration.
    • Note there are built-in Excel characters for each of these measures.
    • Place your results in a tabulation board on a severed subterfuge, suitably labelled.
    • Place your decipherations in a quotation box under the tabulation board. You command nonproduction to constitute the decipherations in a engagement processor then Cut & Paste into the quotation box.
  4. Calculate and decipher the subjoined division/spread measures for variables listed in Bullet 3: Range, Variance and Standard Deviation.
    • Again, there are built in Excel character for each of these measures.
    • Place your results in a tabulation board on a severed subterfuge, suitably labelled. You earn now enjoy three subterfuges.
    • Place your decipherations in a quotation box under the tabulation board. You command nonproduction to constitute the decipherations in a engagement processor then Cut & Paste into the quotation box.