Use the International Stock Market database from “ExcelDatabases.xls†on Blackboard. Use Excel to develop a multipleregression model to predict the DJIA by the Nasdaq, the S&P500, the Nikkei, the Hang Seng, the FTSE 100, and the IPC.Performing a stepwise regression analysis at a 5% level ofsignificance, add the independent variable from Step 2 and continueto perform the stepwise regression analysis until you have reachedthe best linear model. Which independent variables are in the bestlinear model? Check all that apply.
Excel DataHere
https://drive.google.com/file/d/1TQG5r2wzLGk--75whZXyb0SDTHZTWS0S/view?usp=sharing
A: Nasdaq
B: S&P 500
C: Nikkei
D: Hang Seng
E: FTSE 100
F: IPC
Choose AllAnswers That Apply
