Our Services

Get 15% Discount on your First Order

Using the data set that you identified in week 1,

November 14, 2021

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.

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Introducing Pearson Edexcel NVQ/Competence-based qualifications

National Vocational Qualifications (NVQs) or Competence-based qualifications reflect the skills and knowledge needed to do a job effectively. They are work-based qualifications that give learners the opportunity to demonstrate their competence in the area of work or job role to which the qualification relates. NVQs/Competence-based qualifications are outcomes-based with no

Research Paper: Securing Data Overview IT infrastructure of an enterprise

Research Paper: Securing Data Overview IT infrastructure of an enterprise has: a) Database servers, storage systems (SAN & NAS) for data storage b) Computers, applications to process the data c) Network components to enable connectivity among computers and servers In this research, your goal is to secure the data

Intellectual Property – Premium Paper Help

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Read the section in Chapter 1 on Emerging Infectious Diseases.

Read the section in Chapter 1 on Emerging Infectious Diseases. Choose an emerging infectious disease from the textbook or another source and write a one page report using your own words. Use a size 12 font, Times Romans print, double space and head each paragraph. Your report should Include

As a scholar-practitioner, it is important for you to understand

As a scholar-practitioner, it is important for you to understand that just because a hypothesis test indicates a relationship exists between an intervention and an outcome, there is a difference between groups, or there is a correlation between two constructs, it does not always provide a default measure for

The reflection assignment is a seven (10)-page paper based knowledge

The reflection assignment is a seven (10)-page paper based knowledge gained in the course. One topic is selected by the student from the following topics: Cultural Environments of Global Markets, Global Market Opportunities, and Global Market Strategies. The topic is then illustrated using a current event article from a credible

Data obfuscation in virtual environments using fuzzy logic approach

Topic: Data obfuscation in virtual environments using fuzzy logic approach 1) Background or Introduction to describe the basic facts and importance of the research area, the motivation of the research, and the significance to the industry in advancement. 2) Provide a specific Problem Statement and concise description of issues that

Overview You are a business development manager for a life

Overview You are a business development manager for a life sciences organization in the Midwest that has recently found great success through their new cancer treatment drugs. You are part of the team that is planning your organization’s exit strategy, as the owners want to sell the business. As

The threaded discussion will provide the student with the opportunity

The threaded discussion will provide the student with the opportunity to explore different topics, share what he/she is learning with classmates, and gain clarity about the content. This assignment reflects student centered independent learning. The student will:• Apply critical thinking through participation of selected topics• Engage in thoughtful discourse

Your assignment this week is to continue to think about your social entrepreneurship final project and share your idea(s) with your peers. Please post a

Your assignment this week is to continue to think about your social entrepreneurship final project and share your idea(s) with your peers. Please post a brief 1-2 paragraph description of your final project idea below

Why is it important that informatics systems be user friendly?

Why is it important that informatics systems be user friendly? In your encounters with informatics systems, have the systems been user friendly? Explain. What does learnability refer to and what was your experience with learning this healthcare informatics system? What does efficiency refer to and, in your experience, how did

Theorists and Child Development

Next type a paper which explains which two theorists are quite similar in their philosophies. Also include which theorist your philosophy of teaching is best aligned to. This is a double spaced 2-3 page paper. Include your reference list on an additional page. Do NOT include date, cover page, etc.

-At its core, marketing is meant to facilitate exchanges. As

-At its core, marketing is meant to facilitate exchanges. As marketing managers, the most prevalent view we may take of exchange is that of our product for our customers’ money. What other exchanges may occur between marketers and customers? Marketing isn’t limited to goods. Anything can be marketed – ideas,

300 words List the signs and symptoms that point to

nstructions This week, you will prepare a pamphlet. As a

nstructions This week, you will prepare a pamphlet. As a social worker, assume you have been asked to address community leaders and members who are advocating for their social and economic needs to be met. For this assignment, select a specific community need you would like to learn more about.

Jewish literature and civilization

Read the Book of Ruth (4 chapters) from this link: https://www.biblegateway.com/passage/?search=Ruth+1&version=CJB Consider what the reading tells us the history and culture of the period – what does it tell us about people’s beliefs, behaviors, interactions, and the ways they lived and thought about the world around them. Write an analysis

I am taking the following online course, Pearson Education MyLab

I am taking the following online course, Pearson Education MyLab IT. The course has 13 tutorials and tests. Is this something you can do this week, and if so, what is the cost? Thanks Word Volume 1, Chapter 1: Creating Documents with Microsoft Word 2016 Word Volume 1, Chapter 2: Creating Cover

Role of courts

While not immediately as obvious as some other segments of the criminal justice system, courts do play a key role in the public policy making process. Define the role of courts in the public policy making process, and evaluate the key roles courts play in this process. Your essay response