Question

In: Statistics and Probability

The following is a small data set of 25 observations. I want you to calculate some...

The following is a small data set of 25 observations. I want you to calculate some statistics by hand to cement the class material. You can use the regular formula for the variance or the computational formula - I’m just interested in the correct result. If you use the computational formula, you will want to calculate a separate row of each value squared in order to calculate the Sum(x^2). Excel can be used to solve this problem.

VarX

44

34

49

58

17

44

34

49

45

20

26

40

35

37

57

45

70

35

37

42

44

45

27

46

63

  1. Create a Stem and Leaf Plot of the data (it is easy to do in Word by making a two column table and entering the numbers in there, bolding the stems)

b. Calculate the following (show your work):

  • Mean
    • Median
    • Mode
    • Range
    • Variance
    • Std. Deviation
    • Coefficient of Variation

c.   Calculate a z-score for a data value of 70. Describe this in words.

Solutions

Expert Solution

We create a Stem and Leaf Plot of the above data is as below

Stem leaf
1 7
2 0, 6, 7
3 4, 4, 5, 5, 7, 7
4 0, 2, 4, 4, 4, 5, 5, 5, 6, 9, 9
5 7, 8
6 3
7 0

We prepare the following table for finding above values

Ascending Xi
44 17 41.72 5.1984
34 20 41.72 59.5984
49 26 41.72 52.9984
58 27 41.72 265.0384
17 34 41.72 611.0784
44 34 41.72 5.1984
34 35 41.72 59.5984
49 35 41.72 52.9984
45 37 41.72 10.7584
20 37 41.72 471.7584
26 40 41.72 247.1184
40 42 41.72 2.9584
35 44 41.72 45.1584
37 44 41.72 22.2784
57 44 41.72 233.4784
45 45 41.72 10.7584
70 45 41.72 799.7584
35 45 41.72 45.1584
37 46 41.72 22.2784
42 49 41.72 0.0784
44 49 41.72 5.1984
45 57 41.72 10.7584
27 58 41.72 216.6784
46 63 41.72 18.3184
63 70 41.72 452.8384
1043 3727.04

We find the following values using above table

1) Mean :- We find the mean of above data using following formula

Mean =

2) Median :- We find the median of above data using following formula

N = total number of observations = 25

For finding median, we arrange the data in ascending order which is in second column of above table.

Using second column of above table we find median

Median = value of (N + 1)/2 th observation

= value of (25 + 1)/2 th observation

= value of 13th observation

Median = 44

3) Mode :- We find the mode of above data using following way

Mode = Most frequent or repeated value in the data

Here, there are two mode exist because the data values 44 and 45 occuring in 3 times in the above data

the above data is bimodal

Mode = 44 and 45

4) Range :- For finding the range, we first arrange the data in ascending order which is in second column of above table.

Using second column of above table we find the range

The formula of range is

Range = Largest value - Smallest value

For above data,   Largest value = 70 and Smallest value = 17

Range = Largest value - Smallest value

= 70 - 17

Range = 53

5) Variance ():- We find the variance of above data using following formula

  

Variance =

6) Std. Deviation () :- We find the Std. Deviation of above data using following formula

  

  

(Round answer up to 4 decimal places)

Std. Deviation =

7) Coefficient of Variation (C.V.) :- We find the Coefficient of Variation of above data using following formula

  

(Round answer up to 4 decimal places)

Coefficient of Variation =

c. We calculate a z-score for a data value of 70

X = a data value = 70

We find z-score using following formula

Using above values of and we get z-score is as below

  

(Round answer up to 2 decimal places)

The above z-score is 2.32 means that the above value 70 is far away 2.32 standard deviation from mean which is equal 41.72.


Related Solutions

The following is a small data set of 25 observations. I want you to calculate some...
The following is a small data set of 25 observations. I want you to calculate some statistics by hand to cement the class material. You can use the regular formula for the variance or the computational formula - I’m just interested in the correct result. If you use the computational formula, you will want to calculate a separate row of each value squared in order to calculate the Sum(x^2). Excel can be used to solve this problem. VarX 44 34...
I want to calculate a sample size before I collect CATEGORICAL data. If I want no...
I want to calculate a sample size before I collect CATEGORICAL data. If I want no more than 3% margin of error find the sample size I would need for the following intervals. a8) 85% a9) 90% a10) 95% Repeat a8 - 10, but this time with a 5% margin of error a11) 85% a12) 90% a13) 95%
In this case I want you to do some small capital budgeting projects. They are very...
In this case I want you to do some small capital budgeting projects. They are very minimal but will give you a better idea of how firms forecast and analyze to make decisions. The three tools are Payback Method, NPV, IRR. #1 Payback Method You want to purchase an expensive sonography machine that costs $200,000. Ignoring the time value of money and the cost of capital what would your payback period be if you had these cash flows over the...
Generate a simulated data set with 100 observations based on the following model. Each data point...
Generate a simulated data set with 100 observations based on the following model. Each data point is a vector Z= (X, Y) where X describes the age of a machine New, FiveYearsOld, and TenYearsOld and Y describes whether the quality of output from the machine Normal or Abnormal. The probabilities of a machine being in the three states are P(X = New) = 1/4 P(X = FiveYearsOld) = 1/3 P(X = TenYearsOld) = 5/12 The probabilities of Normal output conditioned...
Hello I have a data set of stock price from previous year. I want to know...
Hello I have a data set of stock price from previous year. I want to know the probability of stock price to be more than a certain value after x days starting from where the dataset ends. Which way do i need to approach. I thought of logistic regression, if its correct what do i need to do to move forward. Thank you!
Assume you are a manufacturer of small kitchen electrics, and you want to determine if some...
Assume you are a manufacturer of small kitchen electrics, and you want to determine if some innovative feature designs with unusual shapes and colors developed for town up –scale household dwellers could be successfully marketed even in the neighboring countries. What qualitative research would you recommend and why?                [10 Marks] Distinguish between structured, semi structured and unstructured interviews.                                                                                                                                                                                                               [10 Marks]
Someone sends you the following email – “I have some data that I know is if...
Someone sends you the following email – “I have some data that I know is if of the ‘paired-variety’ – oocyte recordings before and after the application of a peptide. I only have data from 12 pairs.” Given this information –  ANSWER THE FOLLOWING QUESTIONS: 1.         Can a parametric statistical test be used? Explain. 2.         What search terms would you use to look online or in a book to determine what statistical test should be used? Even if you know what test to...
How to calculate Return on Equity?(I just want to learn the formula, no specific data) If...
How to calculate Return on Equity?(I just want to learn the formula, no specific data) If the return on equity is low, how can it be improved? Net Earnings per share Retained earnings, beginning of the year Dividends paid Selling and Admin Expense Operating Profit Interest Expense Income Taxes Net Earnings Retained earnings, end of year Net Sales Cost of goods sold Other income (expense), net Earnings before income taxes
What is median of a set of data? How is median represented for a set of n observations when:
What is median of a set of data? How is median represented for a set of n observations when i) n is odd,  ii) n is even. iii) weighted median of frequency distribution
Use the following data set to calculate the regression equation. What would you estimate the happiness...
Use the following data set to calculate the regression equation. What would you estimate the happiness rating for someone who has 5 children to be? Number of children Happiness Rating 2 1 5 5 8 6 4 3 5 5 6 7 1 2 6 5 3 2
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT