Presentation on definitions, and uses of statistics
Not what you're looking for?
You are assisting both Production departments in analyzing transportation capacity. Data has been collected on truck capacity (# of bags), truck weight, and truck age (in years) for the entire fleet. You have been asked to provide the major summary statistics for this information and you realize you will need to provide explanation of terminology as well.
? Calculate the mean, median, mode, range, variance and standard deviation. You can find the formula for all these functions in any spreadsheet program. In MS Excel, you may have to load the "Data Analysis ToolPak". To do this follow these steps:
o Click on the Microsoft Office Button in the far upper left.
o Click "Excel Options"
o Click "Add-Ins"
o In the Manage box at the bottom, select "Excel Add-ins", then click "Go"
o Select "Analysis ToolPak", then click "Ok"
 (If Analysis ToolPak is not listed in the Add-Ins box, click "Browse" to locate it. If you get prompted that the Analysis ToolPak is not currently installed on your computer, click "Yes" to install it.
o After you load the Analysis ToolPak, the Data Analysis command will become available in the Analysis group on the Data tab.
o
Prepare a 5-6 slide presentation that explains the following:
o the difference between mean, median and mode
o when each is appropriate to use
o the relationship between variance and standard deviation
o why both measures are necessary
o the relationship of these measures to estimation theory.
o Use the Sample Data to illustrate your points
o Create a table on one slide showing the results of the six calculations for each of the three variables
Purchase this Solution
Solution Summary
This solution is comprised of detailed calculation and uses of statistics concepts.
Solution Preview
I have answered all that is needed. The calculation for standard deviation and variance is a little bit of a long process but I ...
Purchase this Solution
Free BrainMass Quizzes
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Lean your Process
This quiz will help you understand the basic concepts of Lean.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.