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 2 years agoRelated 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
ADVERTISEMENT
Latest Questions
- Note: The answers to the following questions should be typed in the block of comments in...
- Python Describe the procedure for setting up the display of an image in a window.
- what are the fundamental similarity and differences between gap and dgap?
- Maria Gonzales is a 57-year-old operating room nurse who works full-time at a local hospital. She...
- Use the bond term's below to answer the question Maturity 7 years Coupon Rate 4% Face...
- What experience have you had with Organization Development or with Change Management? Describe the organization, the...
- 1. Renfro Rentals has issued bonds that have a 12% coupon rate, payable semiannually. The bonds...
ADVERTISEMENT