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

Overview This assignment consists of two sections: Marketing plan and

Overview This assignment consists of two sections: Marketing plan and sales strategy (an MS Word document). Marketing budget (using the Business Plan Financials Excel Template). To successfully complete this assignment, you must attach both documents to the submission area as separate files and then click Submit. Reminders Your company, whether

A variety of models for making decisions are available. Three

A variety of models for making decisions are available. Three of these models are paternalistic, informative, and shared decision making. Discuss the pros and cons of each of these models and the problems that are best suited for the various methods. Determine which method has the strongest possibility of resulting

Review the two articles in Readings and Resources: Judicial Conduct

Review the two articles in Readings and Resources: Judicial Conduct and Discipline in the Federal Courts Filing a Judicial Conduct or Disability Complaint Against a Federal Judge Then, discuss Whether you feel that the review of Federal Judicial misconduct being reviewed by other members is reasonable or should there be

After learning about the various types of placements for students

After learning about the various types of placements for students with IEPs, you can see there are options. What do you think will be your biggest challenge/struggle when determining placements for your students? What type of placement(s) do you see yourself teaching? Explain. What type of placement(s) are you least

Introduction In this three-part assignment, you will design a secure

Introduction In this three-part assignment, you will design a secure network infrastructure. The specific course learning outcome associated with this assignment is: Plan a deployment of software and/or hardware, including implementation and testing considerations. Instructions Part 1 Use Microsoft Visio or an open-source alternative to: Create a network infrastructure

identify 10 awareness days in the month of December (2022).

identify 10 awareness days in the month of December (2022). Make sure to explain the importance of each awareness day. identify 3 awareness days (December 2022) they consider relevant to the social work profession. Why? Provide examples. discuss 2 awareness days (December 2022) that is significant to them. Explain. Students

Japan’s interest in China

Description This is a long essay exam. You will write 1 essays, should be five paragraphs long, minimum word-count requirement of 350 words. There is no maximum word count but students who do well typically stay between 400-600 words. The first paragraph should introduce the topic and contain a thesis

Question 1: Question 1. Expats can face both health and

Question 1: Question 1. Expats can face both health and security issues when overseas. Identify and discuss 3 major issues that might impact the safety of expatriates living abroad in Turkey. As a Global HR manager, what are the three main steps that you would take to ensure the

Enduring understandings and essential questions are part of meaning-making. In

Enduring understandings and essential questions are part of meaning-making. In your mini-unit, you will be addressing only one standard. For this discussion, draft two understandings and two essential questions that support meaning-making and transfer for your students in regard to the standard. Indicate the standard you are addressing in your mini-unit.

The review should be one page, double spaced. The review

The review should be one page, double spaced. The review should be a ½ page summary of the article, and a ½ page application of the material to the real world. Please, see attached the article to review and a document with two samples of two articles review so you

analyze some public opinion data. The three questions below reflect

analyze some public opinion data. The three questions below reflect shifts in public trust in government between 2015 and 2018. Examine them carefully. What general patterns do you see? How would you describe citizens’ attitudes toward the government? What political, social, and/or psychological factors can explain differences in the

1. Complete your Risk Assessment Table for your organization and

1. Complete your Risk Assessment Table for your organization and submit your final table 2. Write 5 goals for prevention/mitigation for your organization or for a small non-profit such as Dress for Success or Adopt a Stray Inc. based on your Risk Assessment. For Question 1 use the Coop

Week 2 – Assignment 1: Analyze Methods to Develop a

Week 2 – Assignment 1: Analyze Methods to Develop a Research ChartInstructionsYou will now add information from this week’s materials to your Research Chart.In the corresponding section, provide the name(s) of the method you reviewed, its primary use and when it should be used, strengths and limitations of the method,

Movie critique Hollywood Film Critique A lot of what we see portrayed in movies may not based in reality, which can lead to confusion about

Movie critique Hollywood Film Critique A lot of what we see portrayed in movies may not based in reality, which can lead to confusion about psychological disorders. Select one of the following films and review the film as a Psychology student, not just a movie-watcher . You must provide a brief

Review the two links below and respond to the following three items: 1) Discuss two things that surprised you the most about African presence in

Review the two links below and respond to the following three items: 1) Discuss two things that surprised you the most about African presence in Asia. 2) Discuss two things that surprised you most about Black presence in early China? 3) How can this new knowledge increase Black Consciousness

The Civil Rights Movement and Diversity

Description Introduction In the 1960’s one event that touched nearly every American was the Civil Rights Movement. The election of President Kennedy ushered the United States into the 1960s with the New Frontier: a bold set of expectations, desires, and liberalism that expanded highly under Lyndon Johnson’s Great Society and

book.chapter.11.pdf Actions Create a risk breakdown structure for John’s move

book.chapter.11.pdf Actions Create a risk breakdown structure for John’s move shown on Figure 11.5. Copy and fill in all the text in the Excel Template I have provided for you here: Risk Breakdown Structure.xlsx Download Risk Breakdown Structure.xlsx Add your name, and save a copy

Introduction A controversial issue today in the American legal system

Introduction A controversial issue today in the American legal system is the justification of the use of force by police officers, given the actions and conduct of citizens. In this assignment, you will explore the requirements for use of force, constitutional rights pursuant to the Bill of Rights when it