SIC Code	No. Emp.	No. Prod. Wkrs.	Value Added by Mfg.	Cost of Materials	Value of Indus. Shipmnts	New Cap. Exp.	End Yr. Inven.	Indus. Grp.
201	433	370	23518	78713	4	1833	3630	1
202	131	83	15724	42774	4	1056	3157	1
203	204	169	24506	27222	4	1405	8732	1
204	100	70	21667	37040	4	1912	3407	1
205	220	137	20712	12030	4	1006	1155	1
206	89	69	12640	13674	3	873	3613	1
207	26	18	4258	19130	3	487	1946	1
208	143	72	35210	33521	4	2011	7199	1
209	171	126	20548	19612	4	1135	3135	1
211	21	15	23442	5557	3	605	5506	2
212	3	2	287	163	1	2	42	2
213	2	2	1508	314	1	15	155	2
214	6	4	624	2622	1	27	554	2
221	52	47	2471	4219	2	292	929	3

QUESTION 7 Use the International Stock Market database from "Excel Databases.xls" on Blackboard. Use Excel to develop a multiple regression model to predict the Nikkei by the DJIA, the Nasdaq, the S&P 500, the Hang Seng, the FTSE 100, and the IPC. Assume a 1% level of significance. What percent of residuals are within 1 standard error? Write your answer as a number rounded to 1 decimal place. Do not include the % sign in your answer. QUESTION 7 Use the International Stock Market database from "Excel Databases.xls" on Blackboard. Use Excel to develop a multiple regression model to predict the Nikkei by the DJIA, the Nasdaq, the S&P 500, the Hang Seng, the FTSE 100, and the IPC. Assume a 1% level of significance. What percent of residuals are within 1 standard error? Write your answer as a number rounded to 1 decimal place. Do not include the % sign in your