BADM 3963 Business Statistics Chemical and Manufacturing Plants Worksheet

User Generated

Enpury_B

Mathematics

BADM 3963

BADM

Description

Hi,

I need step by step solutions for all the problems on a separate worksheet in one Excel file, label the worksheet tabs. Follow all the instructions given at the start of the file. I need to score at least 85% in this assignment.

Thanks

Unformatted Attachment Preview

RIVER TRM TRM TRM TRM TRM TRM TRM TRM FCM LCM LCM TRM FCM TRM TRM LCM LCM TRM TRM TRM TRM SCM SCM LCM SCM SCM SCM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM SPECIES SMBUFFALO SMBUFFALO SMBUFFALO SMBUFFALO CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH LMBASS CCATFISH CCATFISH LMBASS CCATFISH CCATFISH SMBUFFALO CCATFISH SMBUFFALO SMBUFFALO CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH LMBASS CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH SMBUFFALO SMBUFFALO SMBUFFALO SMBUFFALO SMBUFFALO CCATFISH CCATFISH SMBUFFALO CCATFISH CCATFISH LENGTH WEIGHT DDT 44.5 1492 48 46 1524 10 46 1473 44 32.5 520 0.43 46 863 11 40 549 9.4 43.5 810 4.1 46.5 908 2.8 52 1255 1.5 40.5 741 28 48 1151 7.7 23 393 0.22 50.5 1252 50 45 1023 15 25 544 0.11 43.5 754 19 40.5 679 16 48 2006 6.8 44 936 19 43.5 1291 3.4 46.5 1186 13 44.5 1133 2.6 46 1139 3.1 47.5 985 5.4 45 984 9.1 43 965 7.8 45 1084 4.1 48 1329 12 44 897 2.8 28.5 778 0.48 50 1207 7.1 45 911 18 50 1086 5.6 46 1044 4.6 52 1770 8.2 48 1048 6.1 51 1641 13 48.5 1331 6 51 1728 6.6 44 917 5.5 51 1398 11 49 1763 4.5 46 1459 4.2 52 2302 3 46 1614 2.3 46 1444 2.5 35 844 3 36 908 13 33.5 599 0.3 41 961 8.7 42 1058 7.2 TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM CCATFISH CCATFISH CCATFISH CCATFISH SMBUFFALO LMBASS SMBUFFALO LMBASS LMBASS SMBUFFALO SMBUFFALO LMBASS CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH SMBUFFALO SMBUFFALO SMBUFFALO SMBUFFALO SMBUFFALO SMBUFFALO CCATFISH SMBUFFALO SMBUFFALO SMBUFFALO CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH SMBUFFALO CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH 42.5 45.5 48 49 35.5 26 36 26.5 25.5 38 38.5 28 49 44 41 42 42.5 44 41.5 49.5 46 45 43 47 46 41 36 44.5 49 47.5 35 51 42.5 38 41 46 46.5 36 37 29.5 42 47.5 48 47.5 43.5 47.5 43.5 47.5 51.5 49.5 47 47.5 800 1087 1358 1019 1300 532 643 514 441 862 911 733 1498 886 678 1011 947 989 989 1084 1365 1437 1293 1709 1425 1176 980 1460 1671 1717 613 353 909 886 890 1115 724 847 876 476 743 1128 1707 1176 848 1091 715 983 1251 1255 1152 1085 6 10 7.3 15 1.3 0.18 0.25 0.58 0.34 5.7 3.3 0.8 1.5 22 13 3.5 9.3 21 4.7 31 4.8 5.1 5.6 12 21 8 12 5.1 4 10 12 22 10 11 17 5.2 27 18 7.5 3.3 3.7 9.9 4.8 6 6.8 13 8.8 57 96 36 13 13 TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM FCM FCM FCM LCM SCM TRM FCM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM TRM CCATFISH SMBUFFALO SMBUFFALO CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH SMBUFFALO SMBUFFALO SMBUFFALO CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH LMBASS LMBASS SMBUFFALO CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH CCATFISH LMBASS SMBUFFALO CCATFISH LMBASS LMBASS SMBUFFALO SMBUFFALO CCATFISH CCATFISH 47 36 34.5 47 45 45.5 45 45 39 40.5 46 47 48.5 42.5 44 41.5 48 48 49 39 48 43 47.5 29 17.5 32.5 32 40.5 51.5 48 47 41 36 47 45 23.5 30 38 38.5 49.5 50 1118 1285 1178 1031 1083 864 886 965 537 630 1486 1743 2061 732 795 547 1186 1186 1266 465 986 804 1179 793 173 525 556 659 1229 1050 952 826 1433 1704 879 358 856 806 694 1496 1142 61 12 33 9.7 12 4.7 6 3.8 17 12 1.4 6.1 2.8 10 16 23 2 3.5 25 21 8.4 0.74 14 7.4 0.35 0.99 22 9.1 1.4 4.2 12 2 1.9 1.2 3.9 2 2.2 0.45 2.5 2.4 4.3 BADM 3963 Mixed Homework Due 11/2, 9pm Think of this as beginning to review for the Final Exam. Do all work and answer questions in an Excel file. Remember that, while we are using Excel to do this work, you must understand what you are doing in Excel and must be able to do the calculations with a calculator on paper for the exams. Organize your work in a reasonable manner. Use multiple worksheets that are clearly labelled. Document all of your answers clearly and completely. Numbers without labels are meaningless, graphs must have complete labelling. 1. DDT project Chemical and manufacturing plants sometimes discharge toxic-waste materials such as DDT into nearby rivers and streams. These toxins can adversely affect the plants and animals inhabiting the river and the riverbank. The U.S. Army Corps of Engineers conducted a study of fish in the Tennessee River (TRM) and its three tributary creeks: Flint Creek (FCM), Limestone Creek (LCM), and Spring Creek (SCM). A total of 144 fish were captured, and the following variables were recorded for each: 1. 2. 3. 4. 5. River/creek where each fish was captured Species (channel catfish, largemouth bass, or smallmouth buffalo fish) Length (centimeters) Weight (grams) DDT concentration (parts per million) These data are available in the DDT Excel file in Blackboard Copy the data into a new spreadsheet file, save the file as yourlastnameDDT.xls Do all the calculations and develop the graphs using Excel a. Classify each of the five variables recorded as quantitative or qualitative. If quantitative are they discrete or continuous? b. Create a frequency table to show the frequency of occurrence of the three fish species in the 144 captured fish. c. Create two different graphs of the results from part b. d. Create a frequency table and histogram for the weights. Use the Excel Histogram function (demonstrated in podcast) to create a frequency distribution and histogram - show all of the steps of using the 2 to the kth rule to determine Bins (classes) as shown in text pg 28-29 and podcast -Write an interpretation of the histogram e. Create and Interpret a scatterplot to show the relationship between length and weight f. Calculate mean, median, mode, variance and standard deviation for DDT 2. A sample of 165 defective items produced in two factories operated by the same company are classified according to whether the defect is due to poor workmanship or inferior material. Cause of defect Poor workmanship Inferior material A 21 46 Factory B 72 26 Total 67 98 Total 93 72 165 What is the probability that a defective item selected at random: a. is from factory A? b. is due to Inferior material? c. is from factory A or due to Inferior material? d. is from factory A and due to Inferior material? e. Jacob Johnson, the quality supervisor at plant A has found a defective item, what is the probability that it is due to Inferior material? f. A defective item has been found to be due to Inferior material, what is the probability that it came from factory A g. Are the events Cause of defect and Factory independent events? Show the test. 3. To project the inventory for a particular type of computer, Computers R Us analyzed the weekly sales over a long period of time. The probability of distribution of the number of sales, x, is shown in the following table. a. b. c. d. x 0 1 2 3 4 p(x) .06 .16 .20 .35 .23 What is the expected value (average) of sales per week? What is the standard deviation of the number of sales per week? What is the probability that at least 2 computers will be sold? What is the probability that fewer than 3 computers will be sold?
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Please find attached the solution. Let me know if you need anything else.

BADM 3963 Mixed Homework

Due 11/2, 9pm

Think of this as beginning to review for the Final Exam.
Do all work and answer questions in an Excel file. Remember that, while we are using Excel to do this
work, you must understand what you are doing in Excel and must be able to do the calculations with a
calculator on paper for the exams.
Organize your work in a reasonable manner. Use multiple worksheets that are clearly labelled.
Document all of your answers clearly and completely. Numbers without labels are meaningless, graphs
must have complete labelling.
1. DDT project
Chemical and manufacturing plants sometimes discharge toxic-waste materials such as DDT into nearby
rivers and streams. These toxins can adversely affect the plants and animals inhabiting the river and the
riverbank. The U.S. Army Corps of Engineers conducted a study of fish in the Tennessee River (TRM)
and its three tributary creeks: Flint Creek (FCM), Limestone Creek (LCM), and Spring Creek (SCM). A
total of 144 fish were captured, and the following variables were recorded for each:
1.
2.
3.
4.
5.

River/creek where each fish was captured
Species (channel catfish, largemouth bass, or smallmouth buffalo fish)
Length (centimeters)
Weight (grams)
DDT concentration (parts per million)

These data are available in the DDT Excel file in Blackboard
Copy the data into a new spreadsheet file, save the file as yourlastnameDDT.xls
Do all the calculations and develop the graphs using Excel
a. Classify each of the five variables recorded as quantitative or qualitative.
If quantitative are they discrete or continuous?
b. Create a frequency table to show the frequency of occurrence of the three fish species in the 144
captured fish.
c. Create two different graphs of the results from part b.
d. Create a frequency table and histogram for the weights.

Use the Excel Histogram function (demonstrated in podcast) to create a frequency distribution
and histogram
- show all of the steps of using the 2 to the kth rule to determine Bins (classes) as shown
in text pg 28-29 and podcast
-Write an interpretation of the histogram
e. Create and Interpret a scatterplot to show the relationship between length and weight
f. Calculate mean, median, mode, variance and standard deviation for DDT

2. A sample of...


Anonymous
I was having a hard time with this subject, and this was a great help.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Related Tags