Question: how do you find the average, median and standard deviation? using a spreadsheet to calculate. I want give you a few key things about the

how do you find the average, median and standard deviation? using a spreadsheet to calculate.

I want give you a few key things about the standard deviation.

  1. It can not be negative.
  2. Smallest possible value is 0
  3. It is affected by outliers

So, what does it tell us about the data?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

Question 1 You are the teaching assistant of a course and you need to help the instructor to summarize the information of students' final grade. The spreadsheet "Grade Sheet" keeps track of students'...

Q:

1. John Mode had been offered a job in a midsized east Texas town. Obviously, the cost of housing in this city will be an important consideration in a decision to move. John read an article in the...

Q:

question 7 show work please du sales teams during the last quarter. Region A Region B Region Region D 8.3 13.6 8.6 5.9 19.6 3.9 4.1 10.6 17.4 7.2 13.3 32.6 17.3 0.8 1.4 16.7 9.4 10.4 16.4 1.8 19.1...

Q:

The highway mileage (mpg) for a sample of 9 different models of a car company can be found below. Find the mode: Find the midrange: Find the range: Estimate the standard deviation using the range...

Q:

Task 2 Use Tornados data and find two months (month X and month Y ) for which we have the SECOND strongest NEGATIVE correlation . Create the chart where x -axis and y -axis represent the tornadoes...

Q:

Task 2 Use Tornados data and find two months (month X and month Y ) for which we have the SECOND strongest NEGATIVE correlation . Create the chart where x -axis and y -axis represent the tornadoes...

Q:

Task 2 Use Tornados data and find two months (month X and month Y ) for which we have the SECOND strongest NEGATIVE correlation . Create the chart where x -axis and y -axis represent the tornadoes...

Q:

For data set 3-OECD, answer the following questions: Draw a bar chart that shows the average area for G7 member and non-member. Draw a bar chart that shows the percentage of population over 65 years...

Q:

Question: Graph a scatterplot with the below data - Use Excel to do scatterplot - You will want to show your x and y data in the graph and the points on the graph. Label the graph with a Title and...

Q:

Stat 226 Spring 2017 All Sections Homework 5 Due Monday, March 20, 7pm Submission: via Blackboard 1. Confidence Interval Given. Assume I created a 95% confidence interval for the mean hours studied...

Q:

Which of the following statements does NOT apply to not-for-profit corporations? The corporation needs profits to sustain operations. The corporation must file an annual report with the Internal...

Q:

When a city issues general obligation bonds with a face value of $10,000,000 for $10,500,000 and incurs $100,000 of bond issue costs to finance construction of a major general government capital...

Q:

The ages, to the nearest year, of all employees at a certain fastfood outlet are: 19 19 45 20 21 21 18 20 23 17 a. Calculate the mean, variance and standard deviation. b. Calculate the Z scores. c....

Q:

A major customer of an entity suffers a fire after year-end, but just prior to completion of audit fieldwork. The entity believes that this event could have a significant direct effect on the...

Q:

4. What means will you use to achieve these values?

Q:

5. List three of what you would call your core values. For each of these core values, answer the following questions. a. What is the purpose of this value in your life? b. How does this value affect...

Q:

3. What values would you say are your core values?