Question

In: Statistics and Probability

**** DO NOT SOLVE IN EXCEL!!!!**** I need the actual formula & steps!! Consider the following...

**** DO NOT SOLVE IN EXCEL!!!!**** I need the actual formula & steps!!

Consider the following hypotheses and sample​ data, and then complete parts a and b below using α=0.05

H0​:μ≤16

H1​:μ>16

2121     

1818     

1313     

1717     

2323     

1919     

1616     

1919     

1818     

1616  

I am getting the p-value wrong on all of these... I need to know the steps to solve p-value, please. I get all of the other stuff right, just not the p-value :(

Solutions

Expert Solution

Sample mean = 18

Sample standard dev = 2.789

orchestra answered 1 year ago
Next > < Previous

Related Solutions

2. Consider the following all-integer linear program: ***(I NEED to solve this with HAVE EXCEL SPREAD...
2. Consider the following all-integer linear program: ***(I NEED to solve this with HAVE EXCEL SPREAD SHEET AND Sensitivity Report) *** Max 5x1 + 8x2 S.T 6x1 + 5x2 <= 30 9x1 +4x2 <= 36 1x1 + 2x2 <=10 x1, x2 >=and integer a. Graph the constraints for this problem. Use dots to indicate all feasible integer solutions. b. Find the optimal solution to the LP Relaxation. Round down to find a feasible integer solution. c. Find the optimal integer...
please use excel to do it. it also need to come with formula. formula is very...
please use excel to do it. it also need to come with formula. formula is very important. many many thanks. Prepare a sales budget for January through March and for the Quarter in total. The selling price per unit is $50.00. December of the previous year           20,000 January                                     100,000 February                                   80,000 March                                       60,000 April                                         40,000                           2. Prepare a purchases budget and the schedule for Disbursements for Purchases for January through March and for the first quarter in total. Assume...
I need to use Excel to solve the following: A United Nations report shows the mean...
I need to use Excel to solve the following: A United Nations report shows the mean family income for Mexican migrants to the United States is $27,000 per year. A Farm Labor Organizing Committee evaluation of 25 Mexican family units reveals the mean to be $30,000 with a sample standard deviation of $10,000. Does this information disagree with the United Nations report? Apply the .01 significance level.
I need a screenshot of the proper excel model to solve this: A Supply Company maintains...
I need a screenshot of the proper excel model to solve this: A Supply Company maintains 3 plants (production facilities P1, P2, & P3) which supply three fuel distributors (A, B, & C) in the city. Daily plant capacities: P1 = 4500 gallons; P2 = 3000 gallons; P3 = 5000 gallons Daily distributor requirements: A = 5500; B = 2500; C = 4200 Per-gallon transportation costs (in dollars) for each plant-distributor combination are:               A            B            C P1          0.80       0.50      ...
,10. ***( I NEED TO SOLVE THIS WITH EXCEL SPREADSHEET AND SENSITIVITY REPORT) *** Grave City...
,10. ***( I NEED TO SOLVE THIS WITH EXCEL SPREADSHEET AND SENSITIVITY REPORT) *** Grave City is considering the relocation of several police substations to obtain better enforcement in high-crime areas. The locations under consideration together Potential Locations for Substations: Areas Covered: A 1,5,7 B 1,2,5,7 C 1,3,5 D 2,4,5 E 3,4,6 F 4,5,6 G 1,5,6,7 a. Formulate an integer programming model that could be used to find the minimum number of locations necessary to provide coverage to all areas....
Hi, I need the Excel Formula for the below. Thanks much. A business takes out a...
Hi, I need the Excel Formula for the below. Thanks much. A business takes out a 10-year loan for $250,000 at 5.3% interest compounded monthly. What are the formulas to calculate how much interest the business will pay in the first year and how much the business will repay toward the principal? What are the resulting values? Calculate the total cost of the loan in terms of the total interest paid through the l0 years of the loan
Using NPV in Excel how do I solve for: An investment offers the following annual cash...
Using NPV in Excel how do I solve for: An investment offers the following annual cash flows: End of years 1 thru 10, $5000, years 11 thru 20, $7500. If your required return on this investment is 6% what is it worth today?
I need the correct solution with all steps: Consider the following strategy on May 14 involving...
I need the correct solution with all steps: Consider the following strategy on May 14 involving June 18 options: Buy the 125 call at $13.50, Buy the 130 put at $14.50, Sell the 130 call at $11.35, and Sell the 125 put at $ 11.50. If the risk-free rate is 4.56% per year and the time remaining to expiration is 0.0959 years, should the investor execute the position? What is the net present value of the trade?
How do i answer the following question on excel? Consider attending one of the following two...
How do i answer the following question on excel? Consider attending one of the following two colleges as a full-time student. One is a public university with low tuition, while the other is a prestige university (they are both in the same city, so housing costs should be equal for each). Suppose you qualify for a partial scholarship at the private university. The financial information corresponding to attending each school is as follows. Public university ​ Private University Tuition and...
What formula do I use to calculate the Effective Cost of Borrowing (IRR in excel) for...
What formula do I use to calculate the Effective Cost of Borrowing (IRR in excel) for the following cash flows. Years Cashflows 0 $ (94,000.00) 1 884.91 2 833.33 3 786.50 4 744.30 5 706.57 6 698.12 7 705.77 8 712.64 9 718.74 10 724.03 11 728.49 12 732.11 13 734.87 14 736.76 15 737.74 ECB IRR= To calculate ECB, IRR function has to be used using annual payments for cash-flows. However the payments have to be calculated monthly and...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT