Using the International Stock Market data in below, conduct a
stepwise multiple regression procedure to predict DJIA by the
Nasdaq, the S&P 500, the Nikkei, the Hang Seng, the FTSE 100,
and the IPC.
Develop a correlation matrix and discuss the correlations among
all variables. ( please show step by step about doing correlation
in excel and discuss)
Perform a stepwise regression procedure (use α = 0.1) to select
predictor variables for the model. Summarize the results (with
t-values and...