Frequency Distributions And Graphs; Data Description

All posts must be a minimum of 250-300 words. APA reference. 100% original work. no plagiarism.

Using the data set that you identified in the attachment labeled Forum 1-Vehicle, use Excel to find the following descriptive statistics for the price data.

Don't use plagiarized sources. Get Your Custom Essay on
Frequency Distributions And Graphs; Data Description
Just from $13/Page
Order Essay

Descriptive statistics:

Mean

Median

Standard Deviation

Use these summary statistics to make two conclusions or observations about the typical vehicle in the sample. One conclusion must relate to the measure of center (mean/median) and one to the variability (standard deviation) of the vehicles.

Next, add an 11th vehicle to the data set. Choose a “supercar” that costs at least $1 million. Recalculate the summary statistics to include this vehicle.

Descriptive statistics:

Mean

Median

Standard Deviation

Which summary statistics were affected the most by the addition of this outlier? How were they changed, and were you surprised by the results? I encourage you to review the attached document labeled descriptive statistics PDF. This will give you a step by step example on how to calculate these values using Excel. I DO NOT recommend doing this by hand. Let Excel do the heavy lifting for you.

Place Order
Grab A 14% Discount on This Paper
Pages (550 words)
Approximate price: -
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Try it now!

Grab A 14% Discount on This Paper

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.