Chapter 5 Lab Report | Lab Reports Business Statistics

Event A

Door locked

Shape Size Price Cut Grade Shape Size Price Cut Grade

Princess 2.03 21,413 Ultra ideal cut Princess 2.03 21,413 Ultra ideal cut

Emerald 1.50 16,214 Ultra ideal cut Emerald 1.50 16,214 Ultra ideal cut

Using sumproduct, we can determine:

Marquis 1.25 13,762 Ultra ideal cut Marquis 1.25 13,762 Ultra ideal cut

What is the (posterior) probability that a garage door was unlocked, given a theft?

Princess 1.08 12,094 Ultra ideal cut Princess 1.08 12,094 Ultra ideal cut

What is the (posterior) probability that a garage door was locked, given a theft?

Round 1.02 11,506 Ultra ideal cut Round 1.02 11,506 Ultra ideal cut Total

Princess 2.35 20,952 Premium cut Princess 2.35 20,952 Premium cut

Emerald 1.50 13,464 Premium cut Emerald 1.50 13,464 Premium cut

Oval 1.50 13,464 Premium cut Oval 1.50 13,464 Premium cut

Round 1.03 9,324 Premium cut Round 1.03 9,324 Premium cut

Marquis 0.96 8,707 Premium cut Marquis 0.96 8,707 Premium cut

Princess 5.03 44,312 Ideal cut Princess 5.03 44,312 Ideal cut

Marquis 1.75 15,417 Ideal cut Marquis 1.75 15,417 Ideal cut

Round 1.50 13,214 Ideal cut Round 1.50 13,214 Ideal cut

Emerald 1.50 13,214 Ideal cut Emerald 1.50 13,214 Ideal cut

Princess 1.00 8,810 Ideal cut Princess 1.00 8,810 Ideal cut

Round 0.90 7,929 Ideal cut Round 0.90 7,929 Ideal cut

Round 0.75 6,607 Ideal cut Round 0.75 6,607 Ideal cut

Round 0.71 4,125 Ideal cut Round 0.71 4,125 Ideal cut

Round 0.65 5,726 Good cut Round 0.65 5,726 Good cut

Round 0.50 4,405 Good cut Round 0.50 4,405 Good cut

Oval 0.25 2,202 Good cut Oval 0.25 2,202 Good cut

Round 1.50 13,214 Good cut Round 1.50 13,214 Good cut

Princess 2.01 9,667 Average cut Princess 2.01 9,667 Average cut

Princess 1.56 7,503 Average cut Princess 1.56 7,503 Average cut

Oval 1.46 7,022 Average cut Oval 1.46 7,022 Average cut

Marquis 1.45 6,974 Average cut Marquis 1.45 6,974 Average cut

Marquis 1.02 4,906 Average cut Marquis 1.02 4,906 Average cut

Oval 1.01 4,858 Average cut Oval 1.01 4,858 Average cut

Marquis 0.87 4,184 Average cut Marquis 0.87 4,184 Average cut

Round 1.35 11892.92 Average cut Round 1.35 11,893 Average cut

Marquis 2.87 13803.47 Average cut Marquis 2.87 13,803 Average cut

Princess 2.94 14140.14 Ideal cut Princess 2.94 14,140 Ideal cut

Door left

unlocked

Partial preview of the text

Download Chapter 5 Lab Report and more Lab Reports Business Statistics in PDF only on Docsity!

Event A Door locked Shape Size Price Cut Grade Shape Size Price Cut Grade Princess 2.03 21,413 Ultra ideal cut Princess 2.03 21,413 Ultra ideal cut Emerald 1.50 16,214 Ultra ideal cut Emerald 1.50 16,214 Ultra ideal cut Using sumproduct, we can determine: Marquis 1.25 13,762 Ultra ideal cut Marquis 1.25 13,762 Ultra ideal cut What is the (posterior) probability that Princess 1.08 12,094 Ultra ideal cut Princess 1.08 12,094 Ultra ideal cut What is the (posterior) probability that Round 1.02 11,506 Ultra ideal cut Round 1.02 11,506 Ultra ideal cut Total Princess 2.35 20,952 Premium cut Princess 2.35 20,952 Premium cut Emerald 1.50 13,464 Premium cut Emerald 1.50 13,464 Premium cut Oval 1.50 13,464 Premium cut Oval 1.50 13,464 Premium cut Round 1.03 9,324 Premium cut Round 1.03 9,324 Premium cut Marquis 0.96 8,707 Premium cut Marquis 0.96 8,707 Premium cut Princess 5.03 44,312 Ideal cut Princess 5.03 44,312 Ideal cut Marquis 1.75 15,417 Ideal cut Marquis 1.75 15,417 Ideal cut Round 1.50 13,214 Ideal cut Round 1.50 13,214 Ideal cut Emerald 1.50 13,214 Ideal cut Emerald 1.50 13,214 Ideal cut Princess 1.00 8,810 Ideal cut Princess 1.00 8,810 Ideal cut Princess 1.00 8,810 Ideal cut Princess 1.00 8,810 Ideal cut Round 0.90 7,929 Ideal cut Round 0.90 7,929 Ideal cut Round 0.75 6,607 Ideal cut Round 0.75 6,607 Ideal cut Round 0.71 4,125 Ideal cut Round 0.71 4,125 Ideal cut Round 0.65 5,726 Good cut Round 0.65 5,726 Good cut Round 0.50 4,405 Good cut Round 0.50 4,405 Good cut Oval 0.25 2,202 Good cut Oval 0.25 2,202 Good cut Round 1.50 13,214 Good cut Round 1.50 13,214 Good cut Princess 2.01 9,667 Average cut Princess 2.01 9,667 Average cut Princess 1.56 7,503 Average cut Princess 1.56 7,503 Average cut Oval 1.46 7,022 Average cut Oval 1.46 7,022 Average cut Marquis 1.45 6,974 Average cut Marquis 1.45 6,974 Average cut Marquis 1.02 4,906 Average cut Marquis 1.02 4,906 Average cut Oval 1.01 4,858 Average cut Oval 1.01 4,858 Average cut Marquis 0.87 4,184 Average cut Marquis 0.87 4,184 Average cut Round 1.35 11892.92 Average cut Round 1.35 11,893 Average cut Marquis 2.87 13803.47 Average cut Marquis 2.87 13,803 Average cut Princess 2.94 14140.14 Ideal cut Princess 2.94 14,140 Ideal cut Door left unlocked

Total Posterior ing sumproduct, we can determine: hat is the (posterior) probability that a garage door was unlocked, given a theft? hat is the (posterior) probability that a garage door was locked, given a theft? Prior Probability P (A) Conditional Probability P(B| A) Conditional Probability P(B|A) Joint Probability P(A and B) Joint Probability P(A and B) Posterior Probability P(A|B) Probability of theft, given the door is unlocked. Probability of door unlocked and theft Probability of door unlocked, given theft Probability of theft, given the door is locked Probability of door locked and theft Probability of door locked, given theft Total Joint Probabilities

Video # 29

Shape Size Price Cut Grade Count of Price Cut Grade

Princess 2.03 21,413 Ultra ideal cut Price Average cut Good cut Ideal cut

Emerald 1.50 16,214 Ultra ideal cut 500-5500 9.09% 6.06% 3.03%

Marquis 1.25 13,762 Ultra ideal cut 5500-10500 12.12% 3.03% 12.12%

Princess 1.08 12,094 Ultra ideal cut 10500-15500 6.06% 3.03% 12.12%

Round 1.02 11,506 Ultra ideal cut 15500-

Princess 2.35 20,952 Premium cut 20500-

Emerald 1.50 13,464 Premium cut 40500-45500 3.03%

Oval 1.50 13,464 Premium cut Total Result 27.27% 12.12% 30.30%

Round 1.03 9,324 Premium cut

Marquis 0.96 8,707 Premium cut Count of Price Cut Grade

Princess 5.03 44,312 Ideal cut Price Average cut Good cut Ideal cut

Marquis 1.75 15,417 Ideal cut 500-5500 3 2 1

Round 1.50 13,214 Ideal cut 5500-10500 4 1 4

Emerald 1.50 13,214 Ideal cut 10500-15500 2 1 4

Princess 1.00 8,810 Ideal cut 15500-

Princess 1.00 8,810 Ideal cut 20500-

Round 0.90 7,929 Ideal cut 40500-45500 1

Round 0.75 6,607 Ideal cut Total Result 9 4 10

Round 0.71 4,125 Ideal cut Round 0.65 5,726 Good cut Round 0.50 4,405 Good cut Oval 0.25 2,202 Good cut Round 1.50 13,214 Good cut Princess 2.01 9,667 Average cut Princess 1.56 7,503 Average cut Oval 1.46 7,022 Average cut Marquis 1.45 6,974 Average cut Marquis 1.02 4,906 Average cut Oval 1.01 4,858 Average cut Marquis 0.87 4,184 Average cut Round 1.35 11892.9195 Average cut Marquis 2.87 13803.4659 Average cut Princess 2.94 14140.1358 Ideal cut

in this video, using the pivot table tool--we madea contingen

found out that there were 9 average cut totals, 4 good cuts, 1

ultra ideal AND 33 total.

Premium cut Ultra ideal cut Total Result

l--we madea contingency table. Using the units we

ut totals, 4 good cuts, 10 idea cut, 5 premium, 5

Permutation: when the ORDER DOES matter!

Combination: the ORDER DOESNT matter.

wo formulas as mentioned above to calculate the

mbination. The example we used for n=33 AND

82080 and nCr=40920.

we would find for both permutation and

r=5 and find permutation= 95040 and

Event A 25% 0. Door locked 75% 0. Using sumproduct, we can determine: What is the (posterior) probability that a garage door was unlocked, given a theft? What is the (posterior) probability that a garage door was locked, given a theft? Total

Theft

Absolute Value B

G unlocked A1 1.

G locked A2 0.

Theft

Relative Value B

G unlocked A1 0.

G locked A2 0.

P(B1/A1) 0.

P(B1/A2 0.

Prior Probability P (A) Conditional Probability P(B| A) Conditional Probability P(B|A) Door left unlocked Probability of theft, given the door is unlocked. Probability of theft, given the door is locked

Chapter 5 Lab Report, Lab Reports of Business Statistics

Related documents

Partial preview of the text

Download Chapter 5 Lab Report and more Lab Reports Business Statistics in PDF only on Docsity!

Video # 29

Shape Size Price Cut Grade Count of Price Cut Grade

Princess 2.03 21,413 Ultra ideal cut Price Average cut Good cut Ideal cut

Emerald 1.50 16,214 Ultra ideal cut 500-5500 9.09% 6.06% 3.03%

Marquis 1.25 13,762 Ultra ideal cut 5500-10500 12.12% 3.03% 12.12%

Princess 1.08 12,094 Ultra ideal cut 10500-15500 6.06% 3.03% 12.12%

Round 1.02 11,506 Ultra ideal cut 15500-

Princess 2.35 20,952 Premium cut 20500-

Emerald 1.50 13,464 Premium cut 40500-45500 3.03%

Oval 1.50 13,464 Premium cut Total Result 27.27% 12.12% 30.30%

Marquis 0.96 8,707 Premium cut Count of Price Cut Grade

Princess 5.03 44,312 Ideal cut Price Average cut Good cut Ideal cut

Marquis 1.75 15,417 Ideal cut 500-5500 3 2 1

Round 1.50 13,214 Ideal cut 5500-10500 4 1 4

Emerald 1.50 13,214 Ideal cut 10500-15500 2 1 4

Princess 1.00 8,810 Ideal cut 15500-

Princess 1.00 8,810 Ideal cut 20500-

Round 0.90 7,929 Ideal cut 40500-45500 1

Round 0.75 6,607 Ideal cut Total Result 9 4 10

in this video, using the pivot table tool--we madea contingen

found out that there were 9 average cut totals, 4 good cuts, 1

ultra ideal AND 33 total.

Premium cut Ultra ideal cut Total Result

Premium cut Ultra ideal cut Total Result

l--we madea contingency table. Using the units we

ut totals, 4 good cuts, 10 idea cut, 5 premium, 5

Permutation: when the ORDER DOES matter!

Combination: the ORDER DOESNT matter.

wo formulas as mentioned above to calculate the

mbination. The example we used for n=33 AND

82080 and nCr=40920.

we would find for both permutation and

r=5 and find permutation= 95040 and

Theft

Absolute Value B

G unlocked A1 1.

G locked A2 0.

Theft

Relative Value B

G unlocked A1 0.

G locked A2 0.

P(B1/A1) 0.

P(B1/A2 0.