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? Is the sample 4103? 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)
A17 I X V fx A CONSULTING TEAM INC B C D 4060 OXCEL ENERGY INC 1860.29 1860.29 PivotTable Fields X 4061 OXEROX CORP 2407 2407 4062 OXETA TECHNOLOGIES INC 4.08 4.08 Choose fields to add to report: 4063 OXICOR INC 2.86 2.86 4064 OXILINX INC 411.8 411.8 Search 1065 OXM SATELLITE RADIO HLDGS INC 296. 141 296. 14 1066 OXOMA LTD -53.55 -53.55 4067 OXPONENTIAL INC 0.35 Company Name 0.35 5.79 15.79 Stock Ownership Code 4068 OX-RITE INC 4069 OXTO ENERGY INC 94.73 794.73 State 4070 OXTRANA INC 2.13 -2.13 Industry Code 4071 @YAHOO INC 107.94 607.94 Cash and Short-Term Investments (M$) 072 YANKEE CANDLE INC 45.12 45.12 Receivables - Total (M$) 4073 - YELLOW ROADWAY CORP 98 46 98.48 Inventories - Total (M$ 4074 - YOCREAM INTERNATIONAL INC 1.51 1.51 Current Assets - Total (M$) 4075 - YORK INTERNATIONAL CORP 245.42 245.42 Current Liabilities - Total (M$) 4076 - YORK WATER CO 11.11 1 11.11 1077 YOUBET.COM INC 2.14 2.14 Assets - Total (M$) 30.63 30.63 Sales (Net) (M$) 4078 -YOUNG BROADCASTING -CL A 4079 -YOUNG INNOVATIONS INC 23.56 23.56 Operating Income Before Deprec. (M$) 4080 - YOUTHSTREAM MEDIA NETWORKS 6 73 -5.231 4081 GYP CORP 10.29 10.29 1082 YUM BRANDS INC 1471 1471 1083 OZ TEL TECHNOLOGIES INC 3.3 8.31 4084 ZALE CORP 18.91 218.91 4085 0ZAMBA CORP 163 -0.63 4086 -ZAP 3.9 -3 98 4087 OZAPATA CORP 24.09 24.09 4088 - ZEBRA TECHNOLOGIES CP -CLA 42.73 42.73 4089 ZENEX INTERNATIONAL INC 1.76 1.76 4090 - ZEVEX INTERNATIONAL INC .0.23/ -0.23 4091 OZHONE TECHNOLOGIES INC 1.46 -11.46 4092 OZILA INCORPORATED 1.38 0.38 4093 OZILOG INC 8.3 8.3 4094 -ZIMMER HOLDINGS INC 544.8 644.8 1095 0ZIX CORP 24.5 -24.5 4096 -ZOLL MEDICAL CORP 15.03 25.03 Drag fields between areas below: 97 ZOLTEK COS INC -073 -0.73 4098 ZOMAX INC/MN 6.97 6.97 Y Filters Ill Columns 4099 OZONAGEN INC -3.67 -3.67 4100 -ZOOM TECHNOLOGIES INC -0 37 -0.32 4101 ZORAN CORP 4.71 4.71 4102 -ZYGO CORP 7.99 7.99 4103 -ZYNEX MEDICAL HOLDINGS INC -0.04 4104 Grand Total 1041242.06 4105 4106 4107 4108 14109 14110 4111 4112 4113 Row's E Values 4114 Company Name Sum of Operating Inc... |4115 4116 Operating Income Be... 4117 4118 4119 4120 4121 4122 4123 |4124 4125 4126 4127 Sheet4 Sheet1 Sheet3 Sheet5 Sheetz + Defer Layout Update UpdateClipboard Font Alignment Number Styles Cells Editing Analysis | Sensitivity A17 X V fx A CONSULTING TEAMINC B D Formula Bar Data Company Name Sum of Current Assets - Total (M$) Sum of Current Liabilities - Total (MS) PivotTable Fields X 1-800 CONTACTS INC 16.98 1-800-FLOWERS.COM 24/7 REAL MEDIA INC 91.56 Choose fields to add to report: 4.69 18 9 3CI COMPLETE COMPLIANCE CORP 25 Search O 7 3D SYSTEMS CORP 59. 17 10.35 8 3M CO 7720 50821 Company Name 9 3SI HOLDINGS INC 0.72 Stock Ownership Code 10 4 KIDS ENTERTAINMENT INC 0.97 69.77 State 11 4-D NEUROIMAGING 31.84 4.55 Industry Code 12 4NET SOFTWARE IN 13 724 SOLUTIONS INC 0.08 0.02 Cash and Short-Term Investments (M$) 14 7-ELEVEN INC 18.33 675.1 4.24 Receivables - Total (M$) 15 8XB INC 15.4 342.28 Inventories - Total (M$) 16 99 CENTS ONLY STORES 2.79 275.13 57.23 Current Assets - Total (MS] 17 A CONSULTING TEAM INC 5.02 1.95 Current Liabilities - Total (MS] 18 A SV INC 8.5 Assets - Total (MS) 19 A. C. MOORE ARTS & CRAFTS INC 76.49 168.16 Sales (Net) (M$) 20 AAIPHARMA INC 18. 18 55.4 Operating Income Before Deprec. (M$) 21 AAMPRO GROUP INC 111.14 0.66 22 AAON INC 2.13 23 AASTROM BIOSCIENCES INC 64.64 29.2 24 AAVID THERMAL TECHNOLOGIES 11.85 0.58 25 ABATIX CORP 72.19 90.46 14.62 26 ABAXIS INC 7.59 27 ABBOTT LABORATORIES 32.25 6.39 28 ABGENIX INC 0290.42 639.54 365.58 61.29 29 ABIOMED INC 36.98 30 ABLE ENERGY INC 31 ABLE LABORATORIES INC 5.5 8.68 32 ABLEST INC 51.6 16.69 4.76 33 ABM INDUSTRIES INC 600.65 34 ABRAXAS PETROLEUM CORP/NV 256.69 35 ABSS CORP 10.17 12.61 0. 01 36 ABX AIR INC 0.61 89.99 37 ACACIA RESEARCH-ACACIA TECH 113.14 34.33 38 ACCELRB TECHNOLOGY CORP 1.68 Drag fields between areas below. 8.77 39 ACCELRYS INC 0.37 181.5 Y Filters 40 ACCESS PHARMACEUTICALS INC 51.68 Columns 4.82 3.61 41 ACCREDO HEALTH INC. 501.86 E Values 42 ACCUPOLL HOLDING CORP 206.01 43 ACCURIDE CORP 0.15 1.98 136.76 44 ACE CASH EXPRESS IN 60. 12 45 ACE COMM CORP 141.28 136.15 46 ACETO CORP 7.36 3.42 47 ACF INDUSTRIES HOLDING CORP 10.58 38.95 1272 48 ACLARA BIOSCIENCES INC 901.5 49 ACME COMMUNICATIONS INC 91.78 22.63 50 ACME UNITED CORP 22.21 51 ACR GROUP INC 17.19 6.41 48.29 52 ACRES GAMING INC 41 76 22.4 53 ACT TELECONFERENCING INC 12.07 54 ACTEL CORP 13.19 20.3 239.96 18.8 55 ACTION PERFORMANCE COS INC Rows E Values 177.58 56 ACTION PRODUCTS INTL INC 3.03 Company Name Sum of Current Assets... 57 ACTIVANT SOLUTIONS INC 58 ACTIVE POWER INC 72.63 51.41 Sum of Current Liabilit 59 ACTIVEWORLDS CORP 56.77 0.49 60 ACTIVISION IN 0.01 311.88 61 ACTUATE CORP 136.08 68.25 62 ACUITY BRANDS INC 41.16 158.55 9.45 63 ACUSPHERE INC 55.28 4 34 64 ACXIOM CORP 286.33 296.1 65 ADA-ES INC 66 ADAMS GOLF INC 2.04 0.68 7.22 67 ADAMS RESOURCES & ENERGY INC 29.09 68 ADAPTEC INC. 185.65 52.6 857.59 GO ADC TELECOMMUNICATIONS INC 142.3 Sheet4 Sheet1 Sheet3 Sheet5 Sheet2 Defer Layout Update Update Ready 100%Clipboard Font Alignment Number Styles Cells Editing Analysis | Sensitivity A17 X V fx A CONSULTING TEAMINC B C D 4061 XEROX CORP 10335 4062 XETA TECHNOLOGIES INC 13.89 1569 Pivot Table Fields X 4063 XICOR INC 9.68 13.61 4064 XILINX INC 301.55 Choose fields to add to report: 381.13 4065 XM SATELLITE RADIO HLDGS INC 178.56 183.14 4066 XOMA LTD 97.23 30.46 Search 4067 XPONENTIAL INC 15.98 5.08 4068 X-RITE INC 56.11 Company Name 18.21 4069 XTO ENERGY INC 261. 16 20.5 Stock Ownership Code 4070 XTRANA INC 1.01 0.4 State 4071 YAHOO INC 721.71 707.8 Industry Code 4072 YANKEE CANDLE INC 116.9 39.0 Cash and Short-Term Investments (M$) 4073 YELLOW ROADWAY CORP 384.44 863.2 Receivables - Total (M$) 4074 YOCREAM INTERNATIONAL INC 6.13 1.62 Inventories - Total (M$) 4075 YORK INTERNATIONAL CORP 330.8 968.3 4076 YORK WATER CO 4.11 Current Assets - Total (M$] 14.05 4077 YOUBET.COM INC 4.09 Current Liabilities - Total (M$) .12 4078 YOUNG BROADCASTING -CLA 391.63 280. Assets - Total (M$ 4079 YOUNG INNOVATIONS INC 24.57 11.8 Sales (Net) (M$) 4080 YOUTHSTREAM MEDIA NETWORKS 4.42 Operating Income Before Deprec. (M$) 4081 YP CORP 11.26 4.65 4082 YUM BRANDS INC 806 1461 4083 Z TEL TECHNOLOGIES INC 44.28 4084 ZALE CORP 75.32 386.48 354.04 4085 ZAMBA CORP 1.5 2.45 4086 ZAP 2.75 2.07 4087 ZAPATA CORP 201.3 4088 ZEBRA TECHNOLOGIES CP -CLA 583.53 60.99 4089 ZENEX INTERNATIONAL INC 4.96 4090 ZEVEX INTERNATIONAL INC 10.55 4.69 4091 ZHONE TECHNOLOGIES INC 37. 14 54.83 1092 ZILA INCORPORATED 3.56 11.54 4093 ZILOG INC 48.4 27.4 4094 ZIMMER HOLDINGS INC 1338.7 $45.3 4095 ZIX CORP 15.36 4096 ZOLL MEDICAL CORP 48. 11 34. E 4097 ZOLTEK COS INC 39.68 Drag fields between areas below: 4098 ZOMAX INC/MN 131.13 42.55 1099 ZONAGEN INC 0.54 Y Filters Ill Columns 4100 ZOOM TECHNOLOGIES INC 19.06 3.41 4101 ZORAN CORP 220.55 E Values 74.22 4102 ZYGO CORP 96.32 29.44 4103 ZYNEX MEDICAL HOLDINGS INC 0.891 4104 Grand Total 2496856.95 1892130.6 4105 4106 4107 1410 4109 41 10 411 4112 4113 4114 Row's E Values 4115 4116 Company Name Sum of Current Assets... 4117 Sum of Current Liability 4118 4119 |4120 4121 |4122 4173 4124 4125 4126 4127 Sheet4 Sheet1 Sheet3 Sheet5 Sheetz |+ Defer Layout Update Update Ready 100%A17 X V fx A CONSULTING TEAMINC A D Sum of Operating Income Before Deprec. (M$) Company Name PivotTable Fields X Operating Income Before Deprec. (M$) * Tota 3 01-800 CONTACTS INC 8.02 4 1-800-FLOWERS. CO 8.02 27.51 Choose fields to add to report: 024/7 REAL MEDIA IN 1.01 103CI COMPLETE COMPLIANCE CORE 1.89 Search 1.89 7 03D SYSTEMS CORP 5.26 -5.26 8 03M CO 4770 4770 Company Name 9 03SI HOLDINGS INC 0.01 0.01 Stock Ownership Code 10 04 KIDS ENTERTAINMENT INC 62.37 62.37 State 11 04-D NEUROIMAGING -4.22 -4.27 Industry Code 12 04NET SOFTWARE INC -0. 11 - 0.11 Cash and Short-Term Investments (M$) 3 0724 SOLUTIONS INC 15.3 14 07-ELEVEN INC -15.34 Receivables - Total (M$ 10.41 10.41 15 08XB INC Inventories - Total (M$) .3.3 -3.3 16 099 CENTS ONLY STORES Current Assets - Total (M$) 111.15 111.15 17 BA CONSULTING TEAM INC 0.71 0.71 Current Liabilities - Total (M$) 18 BA S VINC 14.21 14.21 Assets - Total (M$) 19 A.C. MOORE ARTS & CRAFTS INC Sales (Net) (M$ 20 AAIPHARMA INC 34.5 34.5 21 BAAMPRO GROUP INC 7.26 Operating Income Before Deprec. (M$] 22 -1.69 -1.69 BAAON INC 6.78 26.78 23 BAASTROM BIOSCIENCES INC 24 AAVID THERMAL TECHNOLOGIES 25 25 BABATIX CORP 0.76 26 GABAXIS INC 0.76 6.43 6.43 27 ABBOTT LABORATORIES 5438.76 BOABGENIX INC 5438.76 - 127.5 29 BABIOMED INC -9.02 I CABLE ENERGY INC 2 . 15 -9.02 31 GABLE LABORATORIES INC 16. 39 2.15 32 16.39 GABLEST INC 1.57 1.57 33 GABM INDUSTRIES INC 34 ABRAXAS PETROLEUM CORP/NV 73.74 2.35 73.74 35 BABSS CORP 2.35 - 0. 18 36 GABX AIR INC - 0. 18 40.21 37 ACACIA RESEARCH-ACACIA TECH - 5.4 GACCELR8 TECHNOLOGY CORP - 5.4 Drag fields between areas below: 39 1.04 BACCELRYS INC 1.23 0.23 Y Filters Ill Columns 40 ACCESS PHARMACEUTICALS INC 7.59 -7.59 GACCREDO HEALTH INC. 67.84 37.84 42 ACCUPOLL HOLDING CORP -5.47 -5.47 43 BACCURIDE CORP 44 BACE CASH EXPRESS INC 68.72 68.72 52.06 5 GACE COMM CORP 52. 06 -1.06 -1.08 46 ACETO CORP 13.97 13.97 47 ACF INDUSTRIES HOLDING CORP 161.5 48 GACLARA BIOSCIENCES INC 161.5 49 19.73 BACME COMMUNICATIONS INC -3.08 -3.08 50 GACME UNITED CORP 2.92 2.92 51 ACR GROUP INC 5.43 52 OACRES GAMING INC 8.84 18.84 53 PACT TELECONFERENCING INC 54 BACTEL CORP 2.04 2.04 13.42 13.42 Row's 65 ACTION PERFORMANCE COS INC E Values 56 ACTION PRODUCTS INTL INC 63.72 63.72 D. 15 Company Name Sum of Operating Inc... 57 ACTIVANT SOLUTIONS INC 41.11 21 .16 41 . 11 Operating Income Be... 58 ACTIVE POWER INC 59 ACTIVEWORLDS CORP 1. 16 -0.04 0.04 10 GACTIVISION INC 19.82 119.82 61 ACTUATE CORP 5.13 2 GACUITY BRANDS INC 5.13 63 ACUSPHERE INC 67.02 67.02 - 17.98 64 GACXIOM CORP 17.98 244. 38 244.38 65 GADA-ES INC 0.45 0.45 66 BADAMS GOLF INC 3.38 3.38 67 ADAMS RESOURCES & ENERGY INC 14.89 14.89 68 GADAPTEC INC. 13.64 43.64 GO PADA TELECOMMUNICATIONS INC 10 0 10 0 Sheet4 Sheet1 Sheets Sheet5 5 Sheet2 + Defer Layout Update Update Ready 100%
