Question

In: Statistics and Probability

Given the year –by- year home run data for Brady Anderson: 1 0 1 4 3...

Given the year –by- year home run data for Brady Anderson:
1
0
1
4
3
2
21
13
12
16
50
18
18
24
19
8
1
Use Excel or Mathematica to answer the following questions:
1. Give the 10% (real world) trimmed mean.____________________
2. Give the 20% (real world) trimmed mean.____________________
3. Calculate the standard deviation_______________________________
4. Calculate the Quartile values Q1 and Q3___________________________


Solutions

Expert Solution

1. Give the 10% (real world) trimmed mean

Ans : 12.41176

2. Give the 20% (real world) trimmed mean

Ans: 10.73333

3. Calculate the standard deviation

Ans: 12.30045

4. Calculate the Quartile values Q1 and Q3

Ans: Q1 = 1.5 &  Q3 = 18.5

##########Solved using excel ########Explanation##############

1) The  trimmed mean in excel calculated using the " TRIMMEA" function .

The answer is

The 10% trim mean is 12.41176

Q2)

The answer is

The 20% trim mean is 10.73333

Q3)

The answer is

The standard deviaion is

s= 12.30045

Q4) Calculating the first quartile

The answer is

Q1 = 1.5

Similarly third quartile

The answer is

Q3 = 18.5

orchestra answered 3 years ago
Next > < Previous

Related Solutions

Given the year –by- year home run data for Brady Anderson: 1 0 1 4 3...
Given the year –by- year home run data for Brady Anderson: 1 0 1 4 3 2 21 13 12 16 50 18 18 24 19 8 1 Use Excel or Mathematica to answer the following questions: a5. Find the IQR________________________________________ b6. Find the median_________________________ c7. Find the Maximum and Minimum values ____________________________ d8. Are there any outliers or extreme outliers? If so, what are they?_______________ e 9. Produce the boxplot (“box and whiskers”) in Mathematica and copy it here....
TABLE 4 Project Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Cash...
TABLE 4 Project Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow A -15000 6000 7000 6000 6000 6000 B -15000 7000 7000 7000 7000 7000 C -18000 12000 2000 2000 2000 2000 "Consider the cash flow of the three projects depicted in Table 4. The cost of capital is 7.5%. If an investor decided to take projects with a payback period of 2 years...
Project Year 0 Year 1 Year 2 Year 3 Year 4 A    -$ 49 $ 25...
Project Year 0 Year 1 Year 2 Year 3 Year 4 A    -$ 49 $ 25 $ 22 $ 22 $ 15 B -$ 101 $ 19 $ 39 $ 51 $ 61 a. What are the IRRs of the two​ projects? b. If your discount rate is 4.8%​, what are the NPVs of the two​ projects? c. Why do IRR and NPV rank the two projects​ differently?
A= 1 2 4 0 1 -2 -1 0 1 2 0 3 8 1 4...
A= 1 2 4 0 1 -2 -1 0 1 2 0 3 8 1 4 . Let W denote the row space for A. (a) Find an orthonormal basis for W and for W⊥. (b) Compute projW⊥(1 1 1 1 1 ).
Given a sequence x(n) for 0 ≤ n ≤ 3, where x(0)=4, x(1)=3, x(2)=2, and x(3)=1,...
Given a sequence x(n) for 0 ≤ n ≤ 3, where x(0)=4, x(1)=3, x(2)=2, and x(3)=1, evaluate your DFT X(k)
exampleInput.txt 1 2 3 0 2 3 4 0 1 3 5 0 1 2 6...
exampleInput.txt 1 2 3 0 2 3 4 0 1 3 5 0 1 2 6 1 5 6 8 2 4 6 7 3 4 5 9 10 5 8 9 4 7 9 6 7 8 6 How can I detect when 'cin' starts reading from a new line. The amount of numbers in each row is unknown. I need them in type 'int' to use the data.
Given the following dataset x   1   1   2   3   4   5 y   0   2   4   5  ...
Given the following dataset x   1   1   2   3   4   5 y   0   2   4   5   5   3 We want to test the claim that there is a correlation between xand y. The level of cretaine phosphokinase (CPK) in blood samples measures the amount of muscle damage for athletes. At Jock State University, the level of CPK was determined for each of 25 football players and 15 soccer players before and after practice. The two groups of athletes are trained...
Given the following dataset x 1 1 2 3 4 5 y 0 2 4 5...
Given the following dataset x 1 1 2 3 4 5 y 0 2 4 5 5 3 We want to test the claim that there is a correlation between xand y. (a) What is the null hypothesis Ho and the alternative hypothesis H1? (b) Using α= 0.05, will you reject Ho? Justify your answer by using a p-value. (c) Base on your answer in part (b), is there evidence to support the claim? (d) Find r, the linear correlation...
Given: x y -5 1 -4 5 -3 4 -2 7 -1 10 0 8 1...
Given: x y -5 1 -4 5 -3 4 -2 7 -1 10 0 8 1 9 2 13 3 14 4 13 5 18 What are the confidence limits (alpha = 0.05) for the true mean value of Y when X = 3?
Given the following data (2, 5, 1, 0, 5, 0, 7, 2, 3) Calculate the 3rd...
Given the following data (2, 5, 1, 0, 5, 0, 7, 2, 3) Calculate the 3rd quartile from your "data". What's the probability that a randomly selected number from your data is even? Consider the events A = "a randomly selected number from your data is even" and B = "a randomly selected number from your data is above the 3rd quartile". Are these events disjoint, independent, neither, or both? Show your work.
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT