Question: Q3 You decide to look at standard variation. For example, the average cost per car ranged from $500 to $2200. $1,800.00 $1600.00 $1,500.00 $500.00 $2200.00

Q3 You decide to look at standard variation.

For example, the average cost per car ranged from $500 to $2200.

$1,800.00

$1600.00

$1,500.00

$500.00

$2200.00

3a Calculate the Standard Deviation for the freight cost per car Use the STDEV function in Excel.If you're unfamiliar with using formulas in Excel, click on the Help meu and search for standard deviation.

3b. Now take out one of the outliers ($ 2200) Calculate the mean and the standard deviation of the remaining four numbers.

3c. What does this tell you about the variation?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

A manufacturer has found that they underestimated their total budget for freight charges. They budgeted the average cost per car from all cities.(Figure 1) Figure 1 Freight Cost per Car Location...

Freight Charge Scenario A manufacturer has found that they underestimated their total budget for freight charges. They budgeted the average cost per car from all cities. (Figure 1) Figure 1 Freight...

Questions: Complete this worksheet. Are the results of the calculations, correct? How logical and complete are your explanations? Scenario A manufacturer of vehicles has found that they...

Montonya Company has the following selected data for the current year: Sales (10,000 units) $90,000 Direct materials 30,000 Direct labor costs 10,000 Variable manufacturing overhead 3,500 Fixed...

Each separate response must have approximately 200 words. Assignments vary widely; however, essays should be written in APA style, with in-text citations and a separate reference listing as...

Need help with these discussion postings (in a document) and assignments (all in separate files), all directions are included as well. FINANCE DIRECTIONS Need to provide 1 original post substantial...

I'm in serious need of help in my accounting class (acc205) . I'm falling behind and I need help with this weeks assignment. for week three for the may-june month . can someone please help me ....

For many years, advertisements for Listerine Antiseptic Mouthwash had impliedly claimed that Listerine was beneficial in the treatment of colds, cold symptoms, and sore throats. An FTC adjudicative...

A portfolio and its benchmark are allocated across three sectors as follows: Sector Portfolio Weight Portfolio Return Benchmark Weight Benchmark Return Technology 30% 12% 20% 10% Healthcare 40% 9%...

The 2020 financial statements for Dartmouth, Inc. are shown below: Dartmouth, Inc. Income Statement For the year ended May 31, 2020 Net Sales Revenue $69,600 Cost of Goods Sold 48,900 Gross Profit...

9qrd,10qrd,11qrd 9. Explain the differences among correlation, experimentation, ethnography, and content analysis as ways of collecting data. What strengths and limitations does each entail? 10. What...

514391 , 2-4qrd ,5qrd ,6qrd 4. Explain the relationship between the methods used to manipulate and measure variables and the concept of operational definition. 5. What is the difference between...

India emerged as an independent country against heavy turmoil."" Justify the statement

Don't copy from Google and don't write in a paper only type the answer Answer briefly within 150 words Write an essay about indian army

Problem 4. (Deterministic Inventory Model. Total 15 pts.) David's Delicatessen sells a special Hebrew sausage. The owner, David Gold, estimates that the demand for the sausage is steady at 500...

3. What does it mean when we say that we attribute a certain meaning to our experiences?

2. In this chapter, the reader should reflect on the following concepts : Thomas theorem, premise of action, utterance and mental constructions.

11. Based on the following rules regarding the confidence we have in information in a communication context, find examples from your everyday life where the rules have relevance: (a) The spatial rule...