Question
In: Statistics and Probability
you must calculate the deviations from the average, the manual correlation calculation and cross check it...
you must calculate the deviations from the average, the manual correlation calculation and cross check it with Excel's correl function. Furthermore, you will generate the scatterplot graph, along with the trendline. Indicate whether there is a strong/weak/no correlation between the two variables.
Question:
The Swiss Hiking Federation is an organization that is known for promoting the same use of the hiking trail system throughout Switzerland. Suppose SHF would like to investigate the linear relationship between the amount of time to hike Wengen-Kleine trail in the Jungfrau region and the age of the hiker. A random sample of 7 hikers on this trail was selected and their age and hiking time is below.
AGE: 24 32 47 40 26 53 38
TIME: 2.7 4.2 5.0 3.8 2.2 2.9 3.0
Using XLS, calculate the correlation coefficient for this sample. Test to see if the population correlation coefficient is not equal to zero using a 90% CI. Here, you will use a two-tail test.
Solutions
orchestra answered 1 year agoRelated Solutions
you must calculate the deviations from the average, the manual correlation calculation and cross check it...
you must calculate the deviations from the average, the manual
correlation calculation and cross check it with Excel's correl
function. Furthermore, you will generate the scatterplot graph,
along with the trendline. Indicate whether there is a
strong/weak/no correlation between the two variables.
Question:
The following tables shows the mpg and curbed weight, in
thousands for eight randomly selected vehicles:
MPG:
28
22
20
34
41
15
19
15
Weight:
2730
2860
3140
2180
2310
4450
3920 2590
Using XLS, calculate...
you must calculate the deviations from the average, the manual correlation calculation and cross check it...
you must calculate the deviations from the average, the manual
correlation calculation and cross check it with Excel's correl
function. Furthermore, you will generate the scatterplot graph,
along with the trendline. Indicate whether there is a
strong/weak/no correlation between the two variables.
Question:
The following tables shows the selling prices, in thousands of
dollars, and the square footages of seven randomly selected homes
recently sold by Century 21 Realtors:
Price:
258
191
253
168
249
245 282
Sqr Ft: 2730 ...
For this question you must calculate the deviations from the average, the manual correlation calculation and...
For this question you must calculate the deviations from the
average, the manual correlation calculation and cross check it with
Excel's correl function. Furthermore, you will generate the
scatterplot graph, along with the trendline. Indicate whether there
is a strong/weak/no correlation between the two variables.
Question :
Fair Isaac, the company that developed the credit score (FICO)
model used by most lenders today, would like to test the linear
relationship between age and credit score of an individual. The
follow...
In this part of the assignment, you will need to calculate the cross-correlation of two random...
In this part of the assignment, you will need to calculate the
cross-correlation of two random signals. In the Appendix: Part II,
we include the function ccorr that gives you the crosscorrelation
of two input vectors.
MATLAB provides other built-in function that may be useful for
this part of the assignment
• max: gives you the maximum value of a vector. For more
information type help max
find: gives you the index corresponding to a value of a vector.
For...
The table below shows standard deviations and correlation coefficients for seven stocks from different countries. Calculate...
The table below shows standard deviations and correlation
coefficients for seven stocks from different countries. Calculate
the variance of a portfolio with equal investments in each stock.
(Use decimals, not percents, in your calculations. Do not
round intermediate calculations. Round your answer to 4 decimal
places.)
Portfolio Varience:?
BHP Billiton
Siemens
Nestlé
LVMH
Toronto Dominion Bank
Samsung
BP
BHP Billiton
1.00
0.28
0.37
0.40
0.16
0.40
0.14
Siemens
1.00
0.34
0.16
0.14
0.31
–0.12
Nestlé
1.00
0.09
0.10
0.02
0.10...
The table below shows standard deviations and correlation coefficients for eight stocks from different countries. Calculate...
The table below shows standard deviations and correlation
coefficients for eight stocks from different countries. Calculate
the variance of a portfolio with equal investments in each stock.
(Use decimals, not percents, in your calculations. Do not
round intermediate calculations. Round your answer to 5 decimal
places.)
BHP
BP
Fiat
Chrysler
Heineken
Korea
Electric
Nestlè
Sony
Tata Motors
BHP
1.00
.34
.38
.45
.14
.45
.16
.29
BP
.34
1.00
.29
.14
.16
.36
−.07
.12
Fiat
.38
.29
1.00
−.03...
The table below shows standard deviations and correlation coefficients for eight stocks from different countries. Calculate...
The table below shows standard deviations and correlation
coefficients for eight stocks from different countries. Calculate
the variance of a portfolio with equal investments in each stock.
(Use decimals, not percents, in your calculations. Do not
round intermediate calculations. Round your answer to 5 decimal
places.)
BHP
BP
Fiat
Chrysler
Heineken
Korea
Electric
Nestlè
Sony
Tata Motors
BHP
1.00
.26
.42
.40
.17
.40
.12
.34
BP
.26
1.00
.34
.17
.12
.33
.49
.17
Fiat
.42
.34
1.00
.09...
Using the following returns, calculate the arithmetic average returns, the standard deviations, and the geometric average...
Using the following returns, calculate the arithmetic average
returns, the standard deviations, and the geometric average returns
for the stock A, B, and C. Assume the returns of stocks are
normally distributed. If Mr. Wong owns a stock C, based on the
historical return data, there is only a 2.5 percent chance that the
stock C will produce a return less than _____ percent in any one
year. If Mr. Wong owns a stock B, which range of
returns would...
Using the following returns, calculate the arithmetic average returns, the standard deviations, and the geometric average...
Using the following returns, calculate the arithmetic average
returns, the standard deviations, and the geometric average returns
for the stock A, B, and C. Assume the returns of stocks are
normally distributed. If Mr. WENG owns a stock C, based on the
historical return data, there is only a 2.5 percent chance that the
stock C will produce a return less than _____ percent in any one
year. If Mr. WENG owns a stock B, which range of
returns would...
Please could you explain below by drawing timeline . and showing manual calculation using financial calculation....
Please could you explain below by drawing timeline . and showing
manual calculation using financial calculation. thank you
2. Assume that you are planning for for your child's college
education. your child will begin college in 18 yrs . you would like
to make annual deposits into an account, starting today, so that
your child may make withdrawals in each of the years 18 through 21
for tuition. Annual tuition is currently $3000, but it is expected
to grow at...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- PUT IN JAVA PROGRAMMING LANGUAGE The Rectangle class: Design a class named Rectangle to represent a...
- Journal article summary on inter-group conflict Peer Reviewed Journal article from past 3 years. Please include...
- "Ethical Considerations" Please respond to the following: Reflect upon the responsibilities placed on auditors by the...
- A Japanese company has a bond outstanding that sells for 93 percent of its ¥100,000 par...
- What is the difference among the principles of modularization, abstraction, encapsulation, and separation of interface and...
- An investment project costs $20,100 and has annual cash flows of $4,400 for six years. ...
- PUT IN JAVA PROGRAMMING The StockB class: Design a class named StockB that contains the following...
ADVERTISEMENT