Posted: March 2nd, 2022

Business Statistics

Remaining Examination

Present your work!

All work should be finished solely by you. Preliminary right here as your signature that you just acquired no outdoors Help in the examination:

1. Given the next set of information (it’s a inhabitants):

three, 20, 2, 12, 91, 12, 23, 12, 29, 19, 12, 39, 44, 37, 18, 29, 12, 27, 12

Utilizing Excel’s embedded formulation and UPLOADING YOUR EXCEL SHEET, discover the:

a. Imply

b. Median

c. Mode

d. Vary

e. Variance of the inhabitants

f. Customary deviation of the inhabitants

g. The 80th percentile

h. The IQR (interquartile vary)

i. Talk about whether or not or not an outlier exists within the information. Help your reply with mathematical proof.

j. The chance of drawing a quantity greater than 22 if one quantity was drawn at random from the checklist

ok. The chance of drawing a quantity greater than 22, not placing it again, after which drawing a second quantity greater than 22 from the checklist

l. The chance of drawing a quantity greater than 22 GIVEN THAT a good quantity was drawn.

Add your Excel sheet to the ultimate that you just used for this. You should present the embedded formulation.

2. Create and insert a scatter diagram with trendline in EXCEL for the next:

Ebook

Pages (x variable)

Worth (y variable)

A

277

$6.00

B

477

$7.25

C

364

$6.80

D

411

$6.50

E

236

$5.95

F

284

$5.99

G

158

$four.55

H

515

$eight.00

Then

a. Present the equation of the trendline on the scatter diagram together with the coefficient of correlation (r squared).

b. Utilizing Pearson’s Product Second Correlation Coefficient, talk about the energy (sturdy, weak…) and kind (optimistic, damaging) of the connection between pages and worth. Be sure to have said the worth of r.

c. In keeping with the trendline, how a lot ought to a ebook that’s 560 pages price?

d. In keeping with the trendline, what number of pages ought to a ebook that price 9 dollars have?

three. Conduct a full speculation check utilizing the p worth methodology for the situation under. Be sure all of the steps are there. An excellent factor to do is to get the prompts from the Week 6 written task.

A pattern of 12 account balances of a credit score firm confirmed a imply buyer steadiness of $2,00zero, however the advertising and marketing supervisor claimed that the imply steadiness for the inhabitants was $2,300. The advertising and marketing supervisor did NOT have the inhabitants normal deviation, however the pattern normal deviation was discovered to be $220. Use the p-value strategy to conduct a full speculation check (all steps) that can be utilized to find out whether or not the imply of all account balances is considerably completely different from $2,300. Let α = .05.

four. Weekly demand at a grocery retailer for a model of breakfast cereal is generally distributed with a imply of 600 bins and normal deviation of 40 bins.

Sketch and insert the z graph with applicable labels and shading after which decide the chance that the weekly demand is:

a. 570 bins or much less.

b. Greater than 650 bins.

c. Between 610 and 630 bins.

5. With a purpose to decide the typical weight of carry-on baggage by passengers in airplanes, a pattern of 673 items of carry-on baggage was collected and weighed. The typical weight was 28.9 kilos. Assume that we all know the usual deviation of the inhabitants to be three.94 kilos. Decide a 95% confidence interval estimate for the imply weight of the carry-on baggage.

Order | Check Discount

Tags: 2803NRS, ACC 502 GCU, ACCCN, ACCT 553 DeVry, ACCT20071, ACCT6003