Week 2: Frequency distributions and graphs; Data description
Using the data set that you identified in week 1, use Excel to find the following descriptive statistics for the price data. 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 Week 2 descriptive statistics PDF at the bottom of the discussions. 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. Once you have posted your initial discussion, you must reply to at least two other learner's post. Each post
must be a different topic. So, you will have your initial post from one topic, your first follow-up post from
a different topic, and your second follow-up post from one of the other topics. Of course, you are more than welcome to respond to more than two learners.” Instructions: You must respond to at least 2 other students outside your initial thread. Responses may include direct questions. In your peer posts, consider the summary statistics of your classmates' data sets. After the supercar was added to the data set, which summary statistic do you think more accurately reflects the typical vehicle price - the mean or median? Compare the standard deviation before the supercar was added and after it was added. Does this indicate greater variability in the original or modified data set? Based on this information, do you feel the standard deviation can help you identify the presence of an outlier? Why or why not? In your responses, refer to the specific data from your classmates' posts. Make sure you include your data set in your initial post as well. Initial Post Due:Thursday, by 11:59 p.m., ET Responses Due:Sunday, by 11:59 p.m., ET
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller sapling. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.99. You're not tied to anything after your purchase.