CSUN T Test on Stock Market Indices Data Questionnaire
Description
Your data indicates that the stock market indices of all the countries studied increased between 2005 and 2006. Unexpectedly, interest rates for all but one country also increased during that period. Perhaps this is partially due to the positive inflation rates in all of these countries. You would like to find out more information. However, there are variations in the direction and in the size of these changes for each country and this complicates your analysis.
Q. 1. Your data indicates that the stock market indices of all the countries studied increased between
2005 and 2006. Unexpectedly, interest rates for all but one country also increased during that
period. Perhaps this is partially due to the positive inflation rates in all of these countries. You
would like to find out more information. However, there are variations in the direction and in the
size of these changes for each country and this complicates your analysis.
a. The Omni Markets Investment – Student Data Spreadsheet.xlsx shows the change in stock
market indices between 2005 and 2006 as a percentage of the 2005 indices. It also shows
the change in interest rates between 2005 and 2006 as a percentage of 2005 interest rates.
Use Excel to calculate the mean and standard deviation for the percent changes in market
indices. Perform the same calculations for the percent changes in interest rates. What do
these numbers indicate?
b. Conduct a hypothesis test to see if the mean percent change in stock market indices between
2005 and 2006 is significantly different from zero. Do this without Excel. Conduct the same
test for the mean percent change in interest rates. Use a significance of .05. How do you
interpret your findings?
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."
