Question

In: Math

Please show step by step work in a spreadsheet or excel so I can follow along:...

Please show step by step work in a spreadsheet or excel so I can follow along:

A federal agency responsible for enforcing laws governing weights and measures routinely inspects packages to determine whether the weight of the contents is at least as great as that advertised on the package. A random sample of 30 containers whose packaging states that the contents weigh 8 ounces was drawn. The weight of each package in ounces can be found in the sheet entitled “Part 2 Question 4”. After conducting the appropriate test, can you conclude with confidence that packages that are labeled as weighing 8 ounces are likely to weigh 8 ounces?

Package Weight in Ounces
7.80
7.91
7.93
7.99
7.94
7.75
7.97
7.95
7.79
8.06
7.82
7.89
7.92
7.87
7.92
7.98
8.05
7.91
7.88
7.95
8.03
8
7.76
7.88
7.99
7.79
8.01
7.8
8.05
8.05

Solutions

Expert Solution

Solution:-

State the hypotheses. The first step is to state the null hypothesis and an alternative hypothesis.

Null hypothesis: u = 8
Alternative hypothesis: u 8

Note that these hypotheses constitute a two-tailed test.

Formulate an analysis plan. For this analysis, the significance level is 0.05. The test method is a one-sample t-test.

Analyze sample data. Using sample data, we compute the standard error (SE), degrees of freedom (DF), and the t statistic test statistic (t).

SE = s / sqrt(n)

S.E = 0.01692

DF = n - 1

D.F = 29
t = (x - u) / SE

t = 4.65

where s is the standard deviation of the sample, x is the sample mean, u is the hypothesized population mean, and n is the sample size.

Since we have a two-tailed test, the P-value is the probability that the t statistic having 29 degrees of freedom is less than -4.65 or greater than 4.65.

Thus, the P-value = less than 0.001.

Interpret results. Since the P-value (almost 0) is less than the significance level (0.05), we have to reject the null hypothesis.


Related Solutions

Please show all work step by step so i can understand Find and classify each critical...
Please show all work step by step so i can understand Find and classify each critical point (as relative maximum, relative minimum, or saddle point) of f(x,y)=2x^3+3x^2+y^2-36x+8y+1
How can I solve this in Excel? Please show how to solve it in excel step...
How can I solve this in Excel? Please show how to solve it in excel step by step. 1) Speedy Wheels is a wholesale distributor of bicycles for the western United States. Its Inventory Manager, Ricky Sapolo, is currently reviewing the inventory policy for one popular model — a small, one-speed girl's bicycle that is selling at the rate of 250 per month. The administrative cost for placing an order for this model from the manufacturer is $200 and the...
PLEASE SHOW ALL WORK. I am teaching myself so I need step by step. If you...
PLEASE SHOW ALL WORK. I am teaching myself so I need step by step. If you use charts, please let me know what was multiplied, divided, etc. for that cell box. Thank you! The Chapman Manufacturing Company has two service departments — manufacturing support and facilities management, and two production departments — assembly and packing/shipping. The distribution of each service department's efforts to the other departments is shown below: FROM TO Support Facilities Assembly Pack/Ship Support 0 % 45 %...
Please show work step by step, No Excel. Thank you! Suppose miller motors can either expense...
Please show work step by step, No Excel. Thank you! Suppose miller motors can either expense or capitalize an asset it has just purchased for $9,000. if it capitalizes the asset, it will depreciate the asset to a book value of zero on a straight line basis of three years. The firm has a marginal tax rate of 38%, and the cost of capital for this asset is 12%. What is the present-value difference to the firm between expensing and...
Please show work step by step, NO EXCEL. Thank you! The investment is $1,000,000, which is...
Please show work step by step, NO EXCEL. Thank you! The investment is $1,000,000, which is depreciated straight line to a zero salvage value over a 10 year life. The asset will be worthless in 10 years. The project will generate, annually, revenues of $800,000, cash operating expenses of $500,000, and depreciation of $100,000. The tax rate is 30%, and the cost of capital is 10%. a. what are the annual cash flow and the NPV? b. what would be...
Please show all your work in Excel, please send me the spreadsheet / workbook. What is...
Please show all your work in Excel, please send me the spreadsheet / workbook. What is the market value of the following bond? Coupon 8% Maturity date 2038 Interest paid semiannually Par Value $1000 Market interest rate 10% What is the market value of the following bond? Coupon 9% Maturity date 2028 Interest paid semiannually Par Value $1000 Market interest rate 8% What is the yield to maturity of the following bond? Coupon 9% Maturity date   2027 Interest paid semiannually...
Please show work step by step, and no Excel. Thank you! Fei Meng, Incorporated has a...
Please show work step by step, and no Excel. Thank you! Fei Meng, Incorporated has a project with the after-tax cash flows shown below. The required return (cost of capital) on the investment is 10%. Compute the:             Year 0 1 2 3 4 Cash flow -70,000 30,000 30,000 30,000 20,000 Payback Discounted payback NPV Profitability index IRR MIRR
Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of...
Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following data change: the April 1 work-in-process costs were $66,000 for direct material and $18,000 for conversion. Work in process, April 1—10,000 units: Direct material: 100% complete, cost of .........................................................................................................$ 22,000 Conversion: 20% complete, cost of ................................................................................................................. 4,500 Balance in work in process, April 1 ..................................................................................................................$  26,500 Units started during April ......................................................................................................................................100,000 Units...
please I want it to step by step and in word posted so I can read...
please I want it to step by step and in word posted so I can read them. Q: If the average realized return of a portfolio is 27.5% per year, the standard deviation of returns is 50%, the portfolio beta is 1.25, the average return of Treasury bills over the same period is 2.5% per year, and the average return on the market is 12.5% per year Calculate i) the Sharpe; ii) Treynor and iii) Jensen    
#6 Please Show step by step, so I can solve similar problems, thanks! Give your answer...
#6 Please Show step by step, so I can solve similar problems, thanks! Give your answer as a whole number but do not round your calculations until you get to the final answer. Jole uses the high-low method of estimating costs. Jole had total costs of $12,373 at its lowest level of activity, when 2,597 units were sold. When, at its highest level of activity, sales equaled 6,091 units, total costs were $28,081. Jole would estimate fixed costs as: _______
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT