Create percent frequency distribution tables

Reference no: EM13918872

Instructions for the Case Report:

1. Download the data (go to Course Content, Learning Modules, Week 4)

2. You can download StatTools (add-in for Excel) to perform some of the functions in Excel (But this is not required). The use of StatTools is optional. But certain functions are easier to perform with StatTools.

Go to https://www.cengagebrain.com/cgi-wadsworth/course_products_wp.pl?fid=M20b&product_isbn_issn=9780840062383&token=.

Select under Book Resources: Palisade Decision Tools

Fill in the form (your name, class, email, etc); Submit

You will see a page: Download Student/Textbook Software

Click on Download Decision Tools Suite Industrial

Download it, unzip, and double-click on the extracted setup executable

Install the program and several shortcuts will be created on your desktop

Click on StatTool and it will open the excel file and automatically add-in is added to Excel

You can start using StatTool (instructions are in the book, Chapter 1-how to insert data first)

Instructions on specific tools are in the appendix to most of the Chapters.

Case Problem 1, Chapter 2

1. Create percent frequency distribution tables for key variables: type of customer, net sales, method of payment, gender, marital status and age (Follow the instructions on pages 40-41 or p.49 (use of PivotTable) )

Need a table with: Frequency, Relative Frequency, and Percent Frequency

2. Create a bar chart or a pie chart (Follow the instructions on pages 42-43)

2. Create a crosstabulation (Follow the instructions on page 69)

3. Create a scatter diagram (Follow the instructions on page 75 or page 96 (with StatTools)

Chapter 3, case study 3:

1. Provide summary statistics (mean, median, mode, standard deviation) for the variables (Follow the instructions on page 102 and page 115 or page 117) or page 161 (with StatTools). Provide graphical summary: construct histogram. (Follow the instructions on pages 54-55 or page 95 (with StatTools))

2. Summarize the frequency, total amount spent and average amount spent by day of week and by type of browser (Follow the instructions on page 49). Use PivotTable.

a) By day of the week:
Row labels (Day)
Count of Day
Sum of Amount Spent
Average of Amount Spent

b) By type of browser:
Row labels (Browser)
Count of Browser
Sum of Amount Spent
Average of Amount Spent

3. Plot scatter diagrams (Follow the instructions on page 75 or page 96). Compute the sample correlation coefficient (Follow the instructions on page 140-141 or page162 (with StatTools))

Attachment:- Assignment.rar

Reference no: EM13918872

Questions Cloud

Preparing a budget and analyzing the results of operations : Preparing a budget and analyzing the results of operations in relation to the budget will help you understand how to use financial information to evaluate the effectiveness of an organization's operations.

Consultant to investigate a potential violation of corporate : Suppose a large aerospace engineering firm has immediately hired you as a consultant to investigate a potential violation of corporate policy and data theft. You have been informed that an employee may have been using corporate email to send confi..

Cost of goods sold and ending inventory : (a) Assuming that the periodic inventory method is used, compute the cost of goods sold and ending inventory under (1) LIFO and (2) FIFO.

Create percent frequency distribution tables : Create percent frequency distribution tables for key variables: type of customer, net sales, method of payment, gender, marital status and age - Summarize the frequency, total amount spent and average amount spent by day of week and by type of brows..

What is missing in the selected companies strategies : Compare and contrast how the selected companies are developing their workforces. Indicate what is missing in the selected companies strategies.

Organization mission-values important strategy formulation : Read the following: The leader of a local health care organization, Ken Janowski, has noticed other health care organizations successfully incorporating strategic management practices. Ken is considering using strategic management for his health c..

Ending inventory at cost for each department : Compute the ending inventory at cost for each department at December 31, assuming the cost-to-retail ratios for the year are 64% forHard covers and 77% for Paperbacks

Essential skills of management : According to Robert Katz, the essential skills of management can be grouped into which of the following three categories

User Account

All Pages