Reference no: EM13922225
Assignment: Numerical Descriptive Statistics
General Instructions:
- For this assignment you will be using Excel to calculate numerical descriptive statistics that describe customers of a fitness equipment company
- Purpose of assignment:
- Practice calculating descriptive statistics for selected variables from a data file
- This is an individual assignment
Assignment Tasks:
This assignment is based on the CardioGood Fitness Case, Chapter 3 (page 144) sections. The data for the case is stored in the attached spreadsheet file. Please read the text of the case and then perform the following tasks:
1. Create two tables of descriptive statistics for the fitness, miles, and income variables, one table for product TM195 and one table for product TM498. The tables should show the following descriptive statistics for each variable:
a. Mean
b. Median
c. 1st Quartile
d. 3rd Quartile
e. Sample variance
f. Sample standard deviation
g. Coefficient of variation
h. Maximum
i. Minimum
j. Range
k. Count
l. Skewness
m. Kurtosis
The tables should have titles, and should be clear and easy to read. Use clear and consistent formatting. For example, format dollar values as dollar values, use a consistent number of places after the decimal point, use borders around your tables, etc.
|
Represent the two-way interaction anova model
: We assign 12 students randomly to each of the four possible cells in the design and obtain a score for each subject on the same 50 point test at the end of the semester.
|
|
Instead allocated to cost objects
: Cannot be traced to cost objects in a cost-effective manner, but are instead allocated to cost objects.Cannot be allocated to cost objects.
|
|
Different media and the number of new customers
: A company is trying to determine how to allocate its $145,000 advertising budget for a new product. The company is considering newspaper ads and television commercials as its primary means for advertising. The following table summarizes the costs ..
|
|
Analysis of moral development involve
: According to Caroline Heldman, which of the following is a question that applies to her sexual object test?
|
|
Assignment on numerical descriptive statistics
: This assignment is based on the CardioGood Fitness Case, Chapter 3 (page 144) sections. The data for the case is stored in the attached spreadsheet file. Please read the text of the case and then perform the following tasks:
|
|
Relationship between strategic and financial planning
: Write a 1,050- to 1,400-word paper in which you describe the relationship between strategic and financial planning. Include the following: A strategic planning initiative for the organization identified - Identify an initiative discussed in the or..
|
|
Jackson and uses the equity method
: Since 2010, Holden has owned 100% of Jackson and uses the equity method to account for its investment in Jackson. Holden has a fiscal year end of December 31 and Jackson has a fiscal year end of October 31. The following information is available: Hol..
|
|
Who benefited and who lost as a result of political change
: Who benefited and who lost as a result of the political change from colony to nation? Why did independence affirm rather than change the basic patterns of society
|
|
Martin company currently produces and sells
: Martin Company currently produces and sells 40,000 units of product at a selling price of $12. The product has variable costs of $6 per unit and fixed costs of $150,000. The company currently earns a total contribution margin of:
|