I need guidance on how to calculate these problem using excel. I used a pivot table to gather information, which I will paste the screenshots below. How do I find the sample? Are these screenshots enough information? I also need to find the correct excel formula to answer these questions. Thanks!
The Sheet2 of Ch8HWData.xls posted provides data on several companies. Use the data to work on the following questions.
1) 99% confidence interval for Operating Income before Depreciation?is:
???
?(Enter answers with three decimal?places)
?
2) 95% confidence interval for the difference between?(Current Assets and Current?Liabilities) is:
??1??2?
?(Enter answers with three decimal?places)
Format Painter Formatting ~ Table Clipboard Font Clear Alignment Filter ~ Select Data Number Styles Cells Editing Analysis | Sensitivity Bi i X V fx A C D E Sum of Operating Income Before Deprec. (MS) F G H K M Operating Income Before Deprec. (MS) Company Name Total A WN PivotTable Fields X 8-632 MIRANT CORP -632 Total -6321 5 -632 Choose fields to add to report: 8-474 UNITED AIRLINES INC -474 6 -474 Total 7 -474 Search 9-326.68 SIRIUS SATELLITE RADIO INC 8 -326.68 Total 326.68 9 326.68 3-296.14 XM SATELLITE RADIO HLDGS INC 296.14 Company Name -296.14 Total 296. 14 Stock Ownership Code 11 8-250.5 JDS UNIPHASE CORP -250.5 State 12 - 2 -250.5 Industry Code 13 3-226.81 MILLENNIUM PHARMACTCLS INC 226.81Cash and Short-Term Investments (M$) 14 -226.81 Total 226.81 Receivables - Total (M$) 12 3-214 UAL CORP -214 Inventories - Total (M$) 16 -214 Total -214 17 3-212.05 CIENA CORP Current Assets - Total (M$) -212.05 18 -212.05 Total Current Liabilities - Total (M$) 19 -212.05 3-204.45 HUMAN GENOME SCIENCES INC -204.45 Assets - Total (M$) 20 -204.45 Total -204.45 Sales (Net) (M$) 21 -154.9 KAISER ALUMINUM CORP 154.9 Operating Income Before Deprec. (M$] 22 -154.9 Total 23 - 154.9 3-154.86 GATEWAY INC - 154 86 24 -154.86 Total 25 154.8 3-144.72 VERTEX PHARMACEUTICALS INC -144.72 26 -144.72 Total 27 -144.72 3-138.68 CORVIS CORP -138.68 28 -138.68 Total -138.68 3-127.89 OSI PHARMACEUTICALS INC 30 -127.89 Total -127.89 31 -127.89 3-127.5 ABGENIX INC -127.5 32 -127.5 Total 33 - 127. 5 -126.59 NPS PHARMACEUTICALS INC 34 -126.59 Total 126.59 35 126.59 -116.56 AMYLIN PHARMACEUTICALS INC 116.56 36 -116.56 Total -116.5 37 3-106.78 CV THERAPEUTICS INC - 106.78 38 -106.78 Total -106.78 Drag fields between areas below: 39 3-104.01 IMCLONE SYSTEMS INC -104.01 40 -104.01 Total Y Filters Ill Columns 41 -104.01 3-102.92 LTX CORP 102.9 42 -102.92 Total -102.92 43 8-99.62 CROWN MEDIA HOLDINGS INC -99.62 44 -99.62 Total 45 99.62 -95.37 MEDAREX INC 95.37 46 -95.37 Total 47 -95.37 3-93 TULARIK INC -93 48 -93 Total 49 3-92.36 LORAL SPACE & COMMUNICATIONS 92.36 50 -92.36 Total 51 92.36 3-87.05 REGENERON PHARMACEUT 87.05 52 -87.05 Total 53 37.05 3-86.2 ALKERMES INC -86.2 54 -86.2 Total -86.2 56 3-85.7 ALLEGHENY TECHNOLOGIES INC -85.7 Rows E Values 56 -85.7 Total 57 - 85.7 3-84.54 MINDSPEED TECHNOLOGIES INC 84.54 Operating Income Be... Sum of Operating Inc... 58 -84.54 Total 84 54 Company Name 59 0-83.98 CUBIST PHARMACEUTICALS INC 83.98 60 -83.98 Total 61 -83.98 8-81.79 INCYTE CORP -81.79 62 -81.79 Total 63 81.79 3-80.99 CELL GENESYS INC - 80.99 64 -80.99 Total - 80.99 65 0-79.97 AMERICA ONLNE LTN AMR -CLA -79.97 66 -79.97 Total 67 -79 97 3-77.59 EXELIXIS INC -77.59 68 -77.59 Total -77.5 2 77 06 AI FVION PHARMACEUTICALS INC 77 06l Sheet4 Sheet1 Sheets Sheet5 Sheetz Ready Defer Layout Update Update 100%Format Painter Formatting * Table Clear Filter ~ Select ~ Data Clipboard Font Alignment Number Styles Cells Editing Analysis | Sensitivity B1 : X V fx B C D E F G H K M 7408 6922 Total 6922 PivotTable Fields 7409 37922 HOME DEPOT INC 7922 7410 7922 Total 7927 Choose fields to add to report: 7411 07953 SPRINT CORP-CONSOLIDATED 7953 7412 7953 Total 7953 Search O 7413 8728 AT&T CORP 8728 7414 8728 Total 8728 7415 #9965.6 MERCK & CO Company Name 9965.6 7416 9965.6 Total 3965.6 Stock Ownership Code 7417 10294 BELLSOUTH CORP 10294 State 7418 10294 Total 10294 Industry Code 7419 10303 PROCTER & GAMBLE CO 10303 Cash and Short-Term Investments (M$) 7420 10303 Total 10303 Receivables - Total (M$) /421 11502 TIME WARNER INC 11502 Inventories - Total (M$) 422 11502 Total 11502 Current Assets - Total (M$) 7423 12740 JOHNSON & JOHNSON 127 40 Current Liabilities - Total (M$) 7424 12740 Total 27 40 Assets - Total (M$ 7425 13092 CONOCOPHILLIPS 13092 Sales (Net) (M$) 7426 13092 Total 13092 427 13152 INTEL CORP 13152 Operating Income Before Deprec. (M$) 7428 13152 Total 13152 7429 13581 GENERAL ELECTRIC CO-PRE FASB 13581 7430 13581 Total 13581 /431 14059 INTL BUSINESS MACHINES CORP 14059 7432 14059 Total 14059 7433 14339 SBC COMMUNICATIONS INC 14339 7434 14339 Total 14339 7435 16979 CHEVRONTEXACO CORP 6979 7436 16979 Total 16970 7437 17001 WAL-MART STORES 17001 7438 17001 Total 17001 /439 17122 PFIZER INC 17122 7440 17122 Total 17122 7441 27289 VERIZON COMMUNICATIONS 7442 27289 Total 27 269 7443 32230 EXXON MOBIL CORP 7444 32230 Tota 32230 Drag fields between areas below: 7445 Grand Total 1041242.06 7446 Y Filters Ill Columns 7447 7448 7450 451 7452 453 7454 7455 7456 457 456 7450 7460 7461 Rows E Values 7462 Operating Income Be... Sum of Operating Inc... 7463 Company Name 464 7465 466 7467 7468 470 7471 7472 7473 Sheet4 Sheet1 Sheets Sheet5 Sheet2 Defer Layout Update Update Ready 100%
