1 answer

Please show how to do work in excel Use Price sheet to answer question. Insert a...

Question:

please show how to do work in excel
Use Price sheet to answer question. Insert a box to type any comment Ameat processing company in the Midwest produces and mar
Draw Page Layout Formulas Data Review View H A A > Hile Home Insert 9 & cut Paste Copy * Format Painter Clipboard D17 - X ===
Clipboard Font H43 B C D E 2.16 2.1 1.82 2.19 2.02 2.19 2.26
Use Price sheet to answer question. Insert a box to type any comment Ameat processing company in the Midwest produces and markets a package of eight small sausage sandwiches. The product is nationally distributed, and the company is interested in knowing the average retail price charged for this item in stores across the country. The company cannot justify a national census to generate this information Based on the company information system's list of all retailers who carry the product, a researcher for the company contacts 36 of these retailers and ascertains the selling prices for the product The data is presented in the Price sheet. Use the price data and a population standard deviation (a) of 113 to determine point estimate for the national retail price of the product Construct a 90% confidence interval to estimate this price. Round your answer to 2 decimal places. Interpret your findings HTML Editor B I VA - AI E *, EE - D V B TT 12pt - Paragraph -
Draw Page Layout Formulas Data Review View H A A > Hile Home Insert 9 & cut Paste Copy * Format Painter Clipboard D17 - X === E 2 Wrap Merge o Calibri 11 BIVA Font fix C D E Alignment G H C vw En hoe 4 A B 1 2.23 2.16 2.12 2.01 1.99 2.23 2.11 2.31 2.07 2.24 1.87 2.1 2.12 1.98 2.17 2.18 2.09 2.08 2.2 2.17 2.3 2.18 2.22 2.05 2.17 2.14 2.29 2.32 2.15 Price ircular References Part 2 Per diem Baseball Players Recruits
Clipboard Font H43 B C D E 2.16 2.1 1.82 2.19 2.02 2.19 2.26

Answers

a 1 liven that n=36; o=0.113 Rolo = 0.1 (90% confidence) Here o is known. So, we have to use } critical value. At x = 0. lo

.

Similar Solved Questions

1 answer
Superior Micro Products uses the weighted average method in its process costing system. During January, the...
Superior Micro Products uses the weighted average method in its process costing system. During January, the Delta Assembly Department completed its processing of 25,000 units and transferred them to the next department. The cost of beginning work in process inventory and the costs added during Janua...
1 answer
What is the slope of the line represented by the equation x = -9?
What is the slope of the line represented by the equation x = -9?...
1 answer
Consider the following random sample: 16, 13, 10, 17, 16, 14, 5, 12, 15, 8. Calculate...
Consider the following random sample: 16, 13, 10, 17, 16, 14, 5, 12, 15, 8. Calculate the first quartile (choose the best answer). A. 9.5 B. 7.5 C. 10.5 D. 0.25 E. 11...
1 answer
Oarty emanded of Apie Using the infprmation plotted above, what type of relationship exists between the...
Oarty emanded of Apie Using the infprmation plotted above, what type of relationship exists between the two variables Determine the slope between Determine the slope between points C and D points E andF 7 Plot the following data Price should be on the Y axis and quantity supplied on the X axis Quant...
1 answer
Calculate the portfolio standard deviation if you put 70% of your money in A and 30%...
Calculate the portfolio standard deviation if you put 70% of your money in A and 30% in D. time A B 1 18.56 12.43 2 12.34 13.45 3 14.12 4.32 4 -1.57 8.54 5 3.12 12.21 6 -9.28 -4.91...
1 answer
Please help me with these 2 questions please all 2 please i need them please Exercise...
please help me with these 2 questions please all 2 please i need them please Exercise 25.46 14 of 21 Constants Consider the circuit of the figure (Figure 1). Part A 12 resistor? What is the total rate at which electrical energy is dissipated in the 5.0 Express your answer using two significant figur...
1 answer
Use the References to access important values if needed for this question. The Pauli Exclusion Principle...
Use the References to access important values if needed for this question. The Pauli Exclusion Principle tells us that no two electrons in an atom can have the same four quantum numbers. For each of the orbitals below list a set of possible quantum numbers. Give only one value for each Orbital mi ms...
1 answer
A cyclist having a mass of 75 kg is riding his bike on a straight road...
A cyclist having a mass of 75 kg is riding his bike on a straight road at a constant velocity of 5 ms-1 towards east. Wind is blowing against him at 6 m/s from the north-east direction at an angle of 22° as per the diagram below. What are the velocities of the headwind and the crosswind acting o...
1 answer
An appliance dealer sells three different models of upright freezers having 12.5, 17.9, and 21.1 cubic...
An appliance dealer sells three different models of upright freezers having 12.5, 17.9, and 21.1 cubic feet of storage space. Let x = the amount of storage space purchased by the next customer to buy a freezer. Suppose that x has the following probability distribution. x p(x) 12.5 0.2 17.9 0....
1 answer
Modify the structure to represent the organic product, if any, expected from each of the oxidation...
Modify the structure to represent the organic product, if any, expected from each of the oxidation reactions. Note that [O] represents an oxidizing agent, such as potassium dichromate, and that [O] is present in excess. Reaction A Select Draw Rings M ore Era CH,CH,CH,OH *-!_!...
1 answer
What is the point group of the following structure of the compound? 0 = X 4....
What is the point group of the following structure of the compound? 0 = X 4. т - ил TI -...
1 answer
The gross requirements for item A are specified for weeks 1 through 12 in the table...
The gross requirements for item A are specified for weeks 1 through 12 in the table that follows Item A, Level 0 00 01 02 03 04 0506 07 08 09 10 11 12 Gross requirements 0 60 0 50 0 700 400 60 0 50 Planned order release???????????? The lead time is 2 weeks: current on hand inventory, at the beginnin...
1 answer
4. If nominal money demand doubles and the real money supply also does what happens to...
4. If nominal money demand doubles and the real money supply also does what happens to the price level ( ). The price level increases by a factor of four b. The price level doubles ). The price level is unchanged. d. The price level falls by one-half. IL Short-Answer O stiens (19 points) 5. (7 point...
1 answer
Meiosis produces haploid gametes, how is the diploid number restored in diploid organisms? Sexual reproduction resulting...
Meiosis produces haploid gametes, how is the diploid number restored in diploid organisms? Sexual reproduction resulting in fertilization Reverse Meiosis O Production of sister chromatids during S phase Synapsis...