Signature Assignment Inferential Statistics Word Document and Excel Spreadsheet Calculations

Anonymous
timer Asked: Mar 28th, 2018
account_balance_wallet $15

Question Description

I am currently in a graduate statistics course and being that I am not strong in this type of math when it comes to the calculations and interpreting concepts from it when writing up reports, I would greatly appreciate a lot of help for the following assignment, along with explaining and giving a break-down on how you obtain the following calculations "step-by-step" on the Excel as well.

About Your Signature Assignment

This signature assignment is designed to align with specific program student learning outcome(s) in your program. Program Student Learning Outcomes are broad statements that describe what students should know and be able to do upon completion of their degree. The signature assignments might be graded with an automated rubric that allows the University to collect data that can be aggregated across a location or college/school and used for program improvements.

Purpose of Assignment

The purpose of this assignment is for students to synthesize the concepts learned throughout the course. This assignment will provide students an opportunity to build critical thinking skills, develop businesses and organizations, and solve problems requiring data by compiling all pertinent information into one report.

Assignment Steps

Resources: Microsoft Excel®, Signature Assignment Databases, Signature Assignment Options, Part 3: Inferential Statistics (all three attached below).

Scenario: Upon successful completion of the MBA program, say you work in the analytics department for a consulting company. Your assignment is to analyze one of the following databases: (my interest is using the "Option 2: Hospital" one).

  • Manufacturing
  • Hospital
  • Consumer Food
  • Financial

Select one of the databases based on the information in the Signature Assignment Options. (attached below that is labeled "Option 2: Hospital Database" for the dataset report I would like to work on).

Provide a 1,600 - 1,760 (excluding cover page and reference wording; not to exceed over 10% of total word count of 1,600 (1,600 x .10 = 160 = 1,760) word detailed, statistical report including the following:

  • Introduction
  • Explain the context of the case
  • Provide a research foundation for the topic
  • Present graphs
  • Explain outliers
  • Prepare calculations
  • Conduct hypotheses tests
  • Discuss inferences you have made from the results
  • Conclusion and Recommendations

This assignment is broken down into four parts:

  • Part 1 - Preliminary Analysis
  • Part 2 - Examination of Descriptive Statistics
  • Part 3 - Examination of Inferential Statistics
  • Part 4 - Conclusion/Recommendations

Part 1 - Preliminary Analysis (3-4 paragraphs)

Generally, as a statistics consultant, you will be given a problem and data. At times, you may have to gather additional data. For this assignment, assume all the data is already gathered for you.

State the objective:

  • What are the questions you are trying to address?

Describe the population in the study clearly and in sufficient detail:

  • What is the sample?

Discuss the types of data and variables:

  • Are the data quantitative or qualitative?
  • What are levels of measurement for the data?

Part 2 - Descriptive Statistics (3-4 paragraphs)

Examine the given data.

Present the descriptive statistics (mean, median, mode, range, standard deviation, variance, CV, and a five-number summary) *Please help provide steps on how to these obtain calculations on this thru Excel*

Identify any outliers in the data.

Present any graphs and charts you think are appropriate for the data.(To present on Word Document report to explain).

Note: Ideally, we want to assess the conditions of normality too. However, for the purpose of this exercise, assume data is drawn from normal populations.

Part 3 - Inferential Statistics (2-3 paragraphs).

Use the Part 3: Inferential Statistics document. (attached below and would be labeled "Option 2: Hospital Database" for the type of industry I would like to work on).

  • Create (formulate) hypotheses (help show a step by step breakdown on how to do this and obtain answers based on the formula)
  • Run formal hypothesis tests
  • Make decisions. Your decisions should be stated in non-technical terms.

Hint: A final conclusion saying "reject the null hypothesis" by itself without explanation is basically worthless to those who hired you. Similarly, stating the conclusion is false or rejected is not sufficient.

Part 4 - Conclusion and Recommendations (1-2 paragraphs).

Include the following:

  • What are your conclusions?
  • What do you infer from the statistical analysis?
  • State the interpretations in non-technical terms. What information might lead to a different conclusion?
  • Are there any variables missing?
  • What additional information would be valuable to help draw a more certain conclusion?

Format your assignment consistent with APA format for citations and references. Also, please include "subject titles for the research report" and direct web link references that I can also look up the information to read over as well

No plagiarism and will be checked!

Tags: introduction No Plagiarism and will be checked Word Document and Excel Spreadsheet Calculations APA format for citations and references Include subject title headings Incude direct web links for APA references used Total Word Count 1600 to 1760 excluding cover page and reference wording Hospital Dataset to Analyze over and Use Explain context of the case Provide a research foundation for the topic Present graphs to outline on Excel and Word Document Explain Outliers Prepare Calculations and explain how to obtain them thru Excel step-by-step for better understanding Conduct Hypothesis tests and show a breakdown on how to obtain those calculations step-by-step Discuss inferences you make from the results Part 1 Premlinary Analysis to include 3-4 paragraphs As a statistics consultant assume all the data is gathered for you State objective What are questions you are trying to address Describe the population in study clearly and in sufficient detail What is the sample Discuss types of data and variables Are the data quantitative or qualitative What levels of measurement for the data Part 2 Descriptive Statistics Examine given data Present descriptive statistics on the mean median mode range standard deviation variance CV and a five number summary on Excel and Word Document Identify outliers Present graphs or charts that are appropriate for the data Assume data is drawn from normal populations Part 3 Inferential Statistics Create formulate hypothesis Run formal hypothesis tests and explain how to obtain those results through a step by step breakdown Make decisions since those decisions should be stated in non-technical terms As a hint for a final conclusion in saying reject the null hypothesis by itself without explanation would be worthless Stating the conclusion is false or rejected would not be sufficient Part 4 Conclusion with Recommendations 1-2 paragraphs What are the conclusions What do you infer from the statistical analysis State the interpretations in non-technical terms What information might lead to a different conclusion Are their any variables missing What additional information would be valuable to help draw a more certain conclusion

Unformatted Attachment Preview

SIC Code No. Emp. 201 202 203 204 205 206 207 208 209 211 212 213 214 221 222 223 224 225 226 227 228 229 231 232 233 234 235 236 237 238 239 241 242 243 244 245 249 251 252 253 254 259 261 262 263 265 No. Prod. Wkrs. 433 131 204 100 220 89 26 143 171 21 3 2 6 52 74 13 17 169 51 55 84 61 27 200 294 38 17 34 1 31 224 83 172 257 51 82 94 273 70 37 81 54 15 116 55 212 Value Added by Mfg. 370 83 169 70 137 69 18 72 126 15 2 2 4 47 63 12 13 147 41 44 76 47 22 178 250 32 14 28 1 25 179 68 147 209 43 68 78 233 53 29 61 39 11 90 42 163 23518 15724 24506 21667 20712 12640 4258 35210 20548 23442 287 1508 624 2471 4307 673 817 8986 3145 4076 3806 4276 1239 9423 11045 1916 599 2063 34 1445 10603 5775 10404 13274 1909 4606 5518 12464 5447 2290 4182 2818 2201 18848 9655 15668 267 271 272 273 274 275 276 277 278 279 281 282 283 284 285 286 287 289 291 295 299 301 302 305 306 308 311 313 314 315 316 317 319 321 322 323 324 325 326 327 328 329 331 332 333 334 335 232 403 121 136 69 604 41 21 65 55 80 115 213 126 51 126 37 76 67 25 14 65 8 61 122 763 15 3 37 2 6 8 7 12 60 64 17 31 45 205 17 72 221 128 35 15 162 182 136 16 57 25 437 28 12 50 39 45 79 106 75 28 75 24 45 43 18 8 54 7 46 95 598 12 2 31 2 4 7 6 9 51 50 13 25 36 152 13 53 174 106 26 11 123 25918 30692 17982 17857 9699 38407 3878 3989 4388 4055 16567 25025 59813 31801 8497 28886 12277 11547 26006 3464 2187 7079 442 4528 7275 55621 1313 162 1907 53 747 328 233 1717 6532 4850 3509 2176 2696 15739 999 7838 29180 9061 4200 1410 16670 336 339 341 342 343 344 345 346 347 348 349 351 352 353 354 355 356 357 358 359 361 362 363 364 365 366 367 369 371 372 373 374 375 376 379 381 382 384 385 386 387 391 393 394 395 396 399 94 32 33 140 45 432 104 259 129 40 300 79 94 205 295 192 265 259 201 392 74 171 108 157 49 258 588 151 772 377 141 31 18 81 47 186 272 268 27 61 6 43 13 103 35 24 179 79 23 27 107 32 315 81 211 99 24 219 55 70 133 211 110 172 96 147 293 51 120 87 117 37 120 368 106 634 190 108 23 14 29 35 68 141 157 17 36 4 30 10 76 26 19 123 5856 3164 3999 11750 4412 27974 6936 19880 7793 3528 21718 10513 9545 18178 22673 19221 23110 41135 17521 25322 6700 14278 9466 13428 3459 38705 84059 13920 105899 45220 7903 2590 1435 9986 3564 21071 29028 31051 2390 14032 415 2761 685 8327 2643 1406 11199 Cost of Materials End Yr. Inven. Indus. Grp. 78713 3630 42774 3157 27222 8732 37040 3407 12030 1155 13674 3613 19130 1946 33521 7199 19612 3135 5557 5506 163 42 314 155 2622 554 4219 929 5357 1427 1061 325 707 267 10421 2083 4140 697 7125 1446 8994 1014 5504 1291 716 356 8926 2314 11121 2727 2283 682 364 197 1813 450 71 17 1321 526 12376 2747 9661 578 19285 3979 18632 3329 2170 355 7290 580 8135 1604 12980 3535 4011 829 5101 447 3755 956 2694 718 3279 725 20596 4257 10604 1502 24634 3976 1 1 1 1 1 1 1 1 1 2 2 2 2 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 6 6 6 6 6 7 7 7 7 28963 8483 6940 8863 2823 29572 3811 1047 2055 1098 11298 34596 27187 19932 9849 46935 11130 13085 132880 6182 4446 7091 496 3805 7195 57264 1865 163 1682 85 395 255 177 943 3527 4254 2282 1387 1183 17010 565 5432 45696 6913 11184 5735 31892 5427 894 1216 3736 874 4300 688 577 504 236 2644 6192 11533 4535 2178 8577 2354 2749 10718 658 670 1067 175 1057 1411 11874 404 35 716 62 199 75 40 282 1505 883 828 700 600 1966 263 1652 12198 1543 1834 694 6377 7 8 8 8 8 8 8 8 8 8 9 9 9 9 9 9 9 9 10 10 10 11 11 11 11 11 12 12 12 12 12 12 12 13 13 13 13 13 13 13 13 13 14 14 14 14 14 4696 2790 9364 8720 3527 31527 4909 21531 6232 1689 19273 12954 11858 23474 14343 16515 18543 60857 21819 13897 5523 12657 12578 11065 7621 29591 44486 13398 223639 42367 7760 4363 1674 8120 5476 8760 18028 16787 1020 8114 382 3646 506 6604 1789 997 8530 938 800 1453 3124 1121 7204 1768 3997 1181 1077 6460 3679 3339 7344 6730 6823 7898 10277 4857 4964 1495 3887 2299 3076 1070 9467 13145 3514 15852 36814 2165 1233 412 4770 1102 6183 7681 7761 426 2290 177 1451 328 2608 799 415 2861 14 14 15 15 15 15 15 15 15 15 15 16 16 16 16 16 16 16 16 16 17 17 17 17 17 17 17 17 18 18 18 18 18 18 18 19 19 19 19 19 19 20 20 20 20 20 20 Hospital Geog. Region 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 Control 1 1 1 1 7 4 4 4 1 1 1 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 5 5 5 2 2 2 1 1 1 1 1 1 1 1 1 1 Service 2 1 2 1 1 2 4 2 2 1 1 3 3 2 4 1 3 2 3 3 3 2 2 1 3 2 2 3 3 2 2 2 2 2 2 2 3 2 1 2 3 1 2 2 1 3 Census 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 2 Births 107 198 356 100 9 159 65 48 253 21 27 30 43 233 2 11 84 219 112 124 50 142 111 140 28 154 150 144 42 77 119 27 15 179 175 461 32 74 414 253 180 184 243 115 215 48 Personnel 312 1077 1027 355 168 3810 735 1 1733 257 169 430 0 2049 211 16 2648 2450 1465 0 1993 2275 1494 1313 451 1689 1583 2017 995 2045 1686 503 126 2026 1412 1517 0 0 2719 1074 1421 762 3194 496 1442 0 792 1762 2310 328 181 1077 742 131 1594 233 241 203 325 676 347 79 505 1543 755 959 325 954 1091 671 300 753 607 929 354 408 1251 386 144 2047 1343 1723 96 529 3694 1042 1071 1525 1983 670 1653 167 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 1 1 1 1 1 1 1 1 7 7 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 1 1 1 1 1 1 1 1 2 3 2 1 1 3 2 1 2 2 3 1 3 2 2 2 2 2 3 2 2 2 4 2 2 1 3 1 2 2 2 1 2 2 1 3 1 1 3 4 1 2 3 3 2 1 3 2 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 2 2 1 1 1 1 2 1 1 1 1 124 189 181 9 28 288 108 154 76 165 295 101 69 12 185 378 114 49 106 460 43 29 125 17 10 14 173 207 223 82 64 139 109 298 52 34 168 21 390 47 80 50 113 45 76 129 60 1107 2989 113 0 0 173 1064 759 1317 1751 0 0 714 99 2243 3966 1308 0 2514 3714 126 556 1327 415 216 339 1217 2641 790 520 35 1168 793 0 0 14 0 0 0 0 776 451 0 145 1284 1 319 793 841 316 93 373 263 943 605 596 1165 568 507 479 136 1456 3486 885 243 1001 3301 337 1193 1161 322 185 205 1224 1704 815 712 156 1769 875 790 308 70 494 111 1618 244 525 472 94 297 847 234 401 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 1 1 1 3 3 3 3 3 5 5 5 5 3 3 3 5 5 5 2 2 2 2 2 2 5 5 5 2 2 2 2 2 2 1 2 4 2 1 3 3 4 1 3 2 1 2 2 3 1 1 1 4 3 1 4 2 1 4 2 3 1 2 3 3 1 4 3 3 2 2 1 1 2 2 2 1 1 1 1 1 1 1 2 2 1 1 2 1 2 2 1 1 1 1 1 2 1 2 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 2 2 1 1 1 1 1 1 1 418 17 138 64 62 131 265 456 40 310 72 19 112 375 15 78 123 54 96 82 1106 30 56 36 127 180 59 127 37 13 100 47 194 172 516 120 179 140 78 68 186 91 340 254 108 61 174 2154 295 496 589 806 701 3968 0 0 3655 0 0 0 0 0 3063 169 66 827 570 0 0 0 342 494 0 0 0 0 286 235 339 398 1275 5699 1364 714 0 0 0 779 0 2202 3346 1071 352 254 3928 198 1231 545 663 820 2581 1298 126 2534 251 85 432 864 66 556 347 239 973 439 1849 102 262 885 549 611 330 1471 75 262 328 377 575 1916 2620 571 703 535 160 202 1330 370 3123 2745 815 576 502 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 2 2 2 2 2 1 1 1 1 1 3 3 3 3 3 3 3 3 3 3 7 7 7 7 7 2 2 2 2 2 1 1 1 3 3 1 1 1 1 1 1 1 1 1 5 5 5 1 3 2 2 1 2 1 4 1 2 2 2 4 1 2 2 1 3 4 1 2 1 1 4 2 1 4 2 2 2 4 3 3 4 2 2 3 3 2 3 4 3 3 3 3 1 2 2 2 1 1 1 1 1 2 1 1 1 1 2 2 1 1 2 1 1 2 1 1 1 1 1 2 1 2 1 1 1 1 1 1 1 2 1 1 1 1 1 2 2 1 1 1 1 306 28 395 923 335 46 316 416 74 86 38 147 232 138 38 245 171 51 28 797 56 69 40 163 231 523 31 43 66 231 11 144 43 185 82 49 24 63 274 93 86 28 25 181 39 302 80 0 0 699 2462 3311 0 4207 0 339 130 91 1143 0 0 509 1026 0 447 1161 0 922 562 78 0 2122 0 0 0 710 1165 466 1106 376 0 637 0 352 447 1227 963 3038 0 0 868 1189 2849 1728 808 50 728 4087 3012 68 3090 1358 576 284 145 2312 1124 336 415 1779 338 453 437 261 609 647 61 2074 2232 948 409 153 741 1625 538 789 395 956 362 144 229 396 2256 731 1477 102 106 939 392 3516 785 188 189 190 191 192 193 194 195 196 197 198 199 200 5 2 2 1 1 1 7 7 7 7 5 5 5 2 2 2 1 2 3 2 1 2 2 1 1 1 1 1 2 1 1 1 1 1 1 1 2 1 1 63 31 170 203 296 83 84 29 187 77 104 85 47 2171 364 0 2993 0 1964 601 387 1946 545 0 838 51 607 273 630 1379 1108 583 514 216 1593 1055 399 834 104 Annual Food Spending ($) 8909 5684 10706 14112 13855 15619 2694 9127 13514 6314 7622 4322 3805 6674 7347 2911 8026 8567 10345 8694 8821 8678 14331 9619 9286 8206 16408 12757 17740 7739 15383 4579 11679 12877 16232 9621 8171 12128 8642 12400 9185 7862 9775 6771 Annual Household Income ($) 56697 35945 52687 74041 63182 79064 25981 57424 72045 38046 52408 41405 29684 49246 41491 26703 48753 55555 71483 50980 46403 51927 84769 59062 57952 58355 81694 69522 96132 57796 88276 32264 65928 69924 91108 54070 47238 77427 59805 60334 54114 40680 58263 52008 Non mortgage household debt ($) 23180 7052 16149 21839 18866 21899 8774 15766 27685 8545 28057 6998 4806 13592 4088 15876 16714 16783 21407 19114 7817 14415 17295 16687 14161 19538 15187 14651 0 22057 1896 7979 0 27330 9876 19908 17819 31340 4963 6632 18593 15202 1486 21713 Region: 1 = NE 2 = MW 3 = S 4=W 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3059 13211 7408 11581 14233 3352 2630 9093 12652 9559 6112 10431 12630 4578 9551 10262 9551 10143 8955 10197 11234 9320 9089 12300 11484 11215 7204 5579 11723 9353 7761 4261 9830 12386 8673 10944 9910 9928 4264 7971 8290 12669 7272 9784 9187 5866 9456 39643 70309 46450 76140 80833 31899 21647 65924 65923 62811 42335 65134 64621 36553 62910 70727 57634 56549 59662 57350 56447 61136 51526 79979 66733 75359 40795 39128 75482 63998 45845 38223 66787 77852 55825 57022 64263 75881 34343 41243 53021 66991 49719 58399 50477 39112 51886 12179 13221 5602 33874 11478 2762 2663 11355 5132 12613 3149 15196 21433 5502 11376 13287 11857 16136 11627 18432 10871 0 4902 17270 15145 15611 8975 6576 12508 0 6671 8576 1178 936 14167 9018 12768 17423 21323 21009 20151 9250 20838 16065 9407 20409 11668 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 6270 9518 10968 8865 9226 4913 6976 8152 2887 8062 8895 8444 6148 4563 8185 3391 7436 9522 11290 10403 4693 5626 11869 13055 8783 13031 3681 5549 4108 6314 7700 7479 9093 9863 8043 9552 9286 7987 3875 10746 6888 5479 6949 10650 5188 5311 4691 34797 62348 78704 53620 51577 34761 60968 51281 25013 59238 47344 52645 35309 34355 50630 29056 48721 50459 72805 56954 39343 38833 55021 77605 57937 63343 36479 40381 26309 41421 54579 40551 50369 54422 51836 73600 51873 48003 36519 75152 44974 48923 43769 75947 41423 40189 36772 146 5201 17002 32004 15922 17704 17799 8167 18763 10815 11814 22469 17139 10612 21187 15735 18363 16478 21238 22218 24696 14371 35576 817 18591 25531 17950 14257 26581 22470 29065 31757 6404 24334 26213 36374 29631 17261 13579 10659 23711 4594 21221 33357 33641 17791 5829 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 8056 11304 8112 8696 5869 3776 11829 13087 10986 5762 11617 9895 16293 8185 13972 11243 4635 10063 8426 7436 11747 15397 6842 9678 12852 10114 8496 6689 15696 9841 12529 10210 8868 6426 11096 10086 2587 12492 8456 6801 6339 7802 9717 6026 5618 10217 8338 59690 53654 59067 65962 37254 33568 56934 88822 59635 38407 78627 47710 64443 58871 87954 54778 39825 49536 60102 49139 51052 70500 54894 60570 57625 56956 61400 50532 72774 69981 66891 67431 64782 38987 64867 50421 27076 51784 54135 53291 49804 52205 72841 46238 45938 77716 59711 19594 23066 240 0 10157 14143 0 17565 27863 18867 11894 22930 31687 35424 11549 12552 19494 12195 13787 22356 4553 12025 16217 4106 31228 25907 1093 17106 17793 21607 17689 19995 14489 17864 5839 8689 17534 20284 22037 23342 34943 28579 22349 20165 10538 18516 7980 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 9048 4017 10906 15148 8830 8481 11358 10553 6969 13219 3543 7326 8458 11766 9908 42106 36462 53403 71290 66759 57616 76221 78202 55164 61171 34093 50647 59898 52884 73629 19786 9935 18177 6696 20972 28767 1373 5920 24795 21482 25969 10750 22940 25970 7112 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 Location: 1 = Metro 2 = Outside Metro 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 Company Type AFLAC Albertson's Allstate Amerada Hess American General American Stores Amoco Arco Chemical Ashland Atlantic Richfield Bausch & Lomb Baxter International Bristol-Myers Squibb Burlington Coat Central Maine Power Chevron CIGNA Cinergy Dayton Hudson Dillard's Dominion Resources Dow Chemical DPL E. I. DuPont DeNemours Eastman Chemical Edison International Engelhard Entergy Equitable Ethyl Exxon FPL Group The GAP Georgia Gulf GIANT Food A&P Great Lakes Chemicals Green Mountain Power Company Hannaford Bros. Hercules Houston Industries Jefferson-Pilot Johnson & Johnson Liberty The Limited Lincoln National Total Revenues 6 4 6 7 6 4 7 2 7 7 5 5 5 1 3 7 6 3 1 1 3 2 3 2 2 3 2 3 6 7 7 3 1 2 4 4 2 3 4 2 3 6 5 6 1 6 Total Assets 7251 14690 20106 8340 3362 19139 36287 3995 14319 19272 1916 6138 16701 1777 954 41950 14935 4353 27757 6817 7678 20018 1356 46653 4678 9235 3631 9562 9666 1064 137242 6369 6508 966 4231 10262 1311 179 3226 1866 6873 2578 22629 660 9189 4899 29454 5219 80918 7935 80620 8536 32489 4116 7777 25322 2773 8707 14977 775 2299 35473 108199 8858 14191 5592 20193 24040 3585 42942 5778 25101 2586 27001 151438 1067 96064 12449 3338 613 1522 2995 2270 326 1227 2411 18415 23131 21453 3185 4301 77175 Lubrizol Lyondell Petrochemical Mallinkrodt May Department Stores McKesson Mercantile Stores Merck Millennium Chemicals Mobil Monsanto Morton Murphy Oil Mylan Laboratories NALCO Chemical Nevada Power NIPSCO Olin Orion Capital Owens & Minor Pacific Corporation J. C. Penney Pennzoil Pfizer Pharmacia & Upjohn Phillips Petroleum Poe & Brown PPG PP&L Resources Progressive Rohm & Haas Ruddick Schering-Plough Sears, Roebuck Stryker Sun Sunamerica Texaco The TJX Companies Torchmark Tosco Travelers Ultramar Diamond Shamrock Union Carbide United States Surgical Corporation UNOCAL UNUM USX-Marathon 2 7 5 1 5 1 5 2 7 2 2 7 5 2 3 3 2 6 5 3 1 7 5 5 7 6 2 3 6 2 4 5 1 5 7 6 7 1 6 7 6 7 2 5 7 6 7 1674 3010 1868 12685 20857 3144 23637 3048 65906 7514 2388 2138 555 1434 799 2587 2410 1591 3117 6278 30546 2654 12504 6710 15424 129 7379 3049 4190 3999 2300 6778 41296 980 10531 2114 46667 7389 2283 13282 37609 10882 6502 1172 6064 4077 15754 1462 1559 2988 9930 5608 2178 25812 4326 43559 10774 2805 2238 848 1441 2339 4937 1946 3884 713 13880 23493 4406 15336 10380 13860 194 6868 9485 7560 3900 885 6507 38700 985 4667 35637 29600 2610 10967 5975 386555 5595 6964 1726 7530 13200 10565 Valero Energy Warner-Lambert WEIS Markets Wellman Winn-Dixie Stores WITCO Zenith Nation Insurance 7 5 4 2 4 2 6 5756 8180 1819 1083 13219 2187 601 2493 8031 972 1319 2921 2298 1252 Return on Equity Earnings per Share 17.1 21.4 20.1 0.2 7.1 12.2 16.7 6.2 9.5 21.8 6 11.5 44.4 12.3 2.4 18.6 13.7 13.3 18 9.2 7.9 23.6 13.9 21.3 16.3 12.3 6.1 4.2 12.3 53.6 19.4 12.2 33.7 228 7.9 6.9 5.5 8.3 9.9 47 8 14.5 26.7 11.1 10.6 0.4 Dividends per Share 2.08 2.08 3.56 0.08 2.19 1.01 2.76 1.14 3.8 5.41 0.89 1.06 3.14 1.18 0.16 4.95 4.88 1.59 1.7 2.31 2.15 7.7 1.2 2.08 3.63 1.73 0.33 1.03 2.86 0.71 3.37 3.57 1.3 2.39 1.18 1.66 1.19 1.57 1.4 3.18 1.66 3.47 2.41 3.34 0.79 0.21 Average P/E Ratio 0.22 0.63 0.36 0.6 1.4 0.34 1.4 2.8 1.1 2.83 1.04 1.13 1.52 0.02 0.9 2.28 1.1 1.8 0.33 0.16 2.58 3.24 0.91 1.23 1.76 1 0.38 1.8 0.2 0.5 1.63 1.92 0.2 0.32 0.78 0.35 0.62 1.61 0.54 1 1.5 1.04 0.85 0.77 0.48 1.96 11.5 19 10.6 698.3 21.2 23.5 16.1 40.4 12.4 3.8 2.6 47.2 24.1 12.9 79.6 15.2 11.4 22.4 16.2 15.7 17.7 11.6 14.3 27.9 16 13.6 61.8 25.4 13.4 12.6 17.1 14.4 22 11.8 26.9 17.8 40.5 14 26.6 14.5 13.7 13.3 24.1 12.7 26.7 300.2 19 46.2 14.8 20.5 11 7.9 36.6 12.6 16.8 7.2 12.3 12.3 13.5 25 10.1 14.1 17.4 16 9.4 5.2 7.7 15.8 27.9 5.8 19.9 25.1 28.5 11.4 18.7 19.8 12.5 51.2 20.3 20.5 18 14.7 20.9 26.3 17.5 10.9 14.9 9.5 28.8 7.5 28.9 15.2 12.6 2.66 3.58 2.47 3.11 1.59 3.53 3.74 2.47 4.01 0.48 1.48 2.94 0.82 2.1 1.65 1.53 3 4.15 0.6 0.68 2.1 3.76 1.7 0.61 3.61 1.48 3.94 1.8 5.31 2.13 1.02 1.95 2.99 1.28 2.7 1.8 4.87 1.75 2.39 1.37 2.54 1.94 4.53 1.21 2.65 2.59 1.58 1.01 0.9 0.66 1.2 0.5 1.19 1.69 0.6 2.12 0.5 0.36 1.35 0.16 1 1.6 0.9 1.2 0.6 0.18 1.08 2.13 1 0.68 1.08 1.34 0.35 1.33 1.67 0.24 0.63 0.32 0.74 0.92 0.11 1 0.3 1.75 0.09 0.59 0.24 0.4 1.1 0.79 0.16 0.8 0.56 0.76 14.5 6.4 16 16.2 26 16.3 26.6 8.3 17.2 90.7 25.2 18 22.4 18.3 14.2 14.4 14.5 9.8 21.7 34.2 26.9 17.1 35.4 56.2 12.4 16.3 14.7 12 17 13.4 17 24.6 17.4 27.2 13 19.5 11.5 8.2 14.2 23 17 16.1 10.7 29 15.5 17 19.8 9.6 30.7 9.2 4.8 15.3 14 7.8 2.03 1.04 1.87 0.97 1.36 1.55 1.57 0.42 0.51 0.94 0.35 0.98 1.12 1 17.2 35.7 16.9 20.5 27.2 24.9 17 Week 6 Options QNT/561 Version 9 University of Phoenix Material Option 1: Manufacturing Database This database contains six variables taken from 20 industries and 140 subindustries in the United States. Some of the industries are food products, textile mill products, furniture, chemicals, rubber products, primary metals, industrial machinery, and transportation equipment. The six variables are Number of Employees, Number of Production Workers, Value Added by Manufacture, Cost of Materials, End-of-Year Inventories, and Industry Group. Two variables, Number of Employees and Number of Production Workers, are in units of 1000. Three variables, Value Added by Manufacture, Cost of Materials, and Endof-Year Inventories, are in million-dollar units. The Industry Group variable consists of numbers from 1 to 20 to denote the industry group to which the particular subindustry belongs. Option 2: Hospital Database This database contains observations for six variables on U.S. hospitals. These variables include Geographic Region, Control, Service, Census, Number of Births, and Personnel. The region variable is coded from 1 to 7, and the numbers represent the following regions: 1 = South 2 = Northeast 3 = Midwest 4 = Southwest 5 = Rocky Mountain 6 = California 7 = Northwest Control is a type of ownership. Four categories of control are included in the database: 1 = government, nonfederal 2 = nongovernment, not-for-profit 3 = for-profit 4 = federal government Service is the type of hospital. The two types of hospitals used in this database are: 1 = general medical 2 = psychiatric Option 3: Consumer Food The consumer food database contains five variables: Annual Food Spending per Household, Annual Household Income, Non-Mortgage Household Debt, Geographic Region of the U.S. of the Household, and Household Location. There are 200 entries for each variable in this database representing 200 different households from various regions and locations in the United States. Annual Food Spending per Household, Annual Household Income, and Non-Mortgage Household Debt are all given in dollars. The variable Region tells in which one of four regions the household resides. In this variable, the Northeast is coded as 1, the Midwest is coded 2, the South is coded as 3, and the West is coded as 4. The variable Location is coded as 1 if the household is in a metropolitan area and 2 if the household is outside a metro area. The data in this database were randomly derived and developed based on actual national norms. Option 4: Financial Database Copyright © 2017 by University of Phoenix. All rights reserved. 1 Week 6 Options QNT/561 Version 9 The financial database contains ...

This question has not been answered.

Create a free account to get help with this and any other question!

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors