Create percent frequency distribution tables

Assignment Help Basic Statistics
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 http://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

Previous Q& A

  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

  During the accounting period

The following information was drawn from the accounting records of Vanner Manufacturing Company.

  Hows trategic for non-profit differ from profit-making firms

Since it will be years, if ever, that most of you will be in a position to establish strategy, why do you want to study it, How do you explain the success of firms which do not use a formal strategic planning process?

  Mutually exclusive project-project with initial cash outflow

Consider two mutually exclusive projects with the following cash flows: Project S is a 4 year project with initial (time 0) cash outflow of 3000 and time 1 through 4 cash inflows of 1500, 1200, 800 and 300 respectively. Project L is a 4 year project ..

  Investigating student enrollment persistence

A researcher wants to investigate the proportion of married men who are happy with their marriage to do this, he takes a sample of 100 men and finds that 72 reported being happy with their marriage. Should a confidence interval be constructed to d..

  Farey fractions of level one

Write a program that for a number n entered by the user creates-by constantly extending it-a linked list of fractions at level n and then displays them.

  Consider the production cost information

Consider the production cost information for Mama Italiano Sauce given below: Mama Italiano Sauce Production Cost Budget April 2008 Production - Jars of sauce 20,000 Ingredient cost (variable) $16,000 Labor cost (variable) 9,000 Rent (fixed) 4,000 De..

Reviews

Write a Review

 

Similar Q& A

  Find the estimated margin of error

Construct the confidence interval to find the estimated margin of error. Then find the sample mean and you are given the sample mean and sample standard deviation. Use this information to construct the 90% and 95% confidence interval for the popula..

  Create interval estimate for true proportion of retirement

Formulate an 84% interval estimate for the true proportion of employees within one year of retirement in the entire corporation.

  What proportion of scores in normal distribution are higher

What proportion of the scores in a normal distribution are higher than a T-score of 70, what Z-score has 90% of the scores below it and what deviation IQ score ranges would include 90% of the population

  Develop regression model for predicting the selling price

Pick a random sample of 50 homes from the enclosed 90 cases.  Double the asking price and selling price and use this data to develop three predictive models:

  A clinical trial tests a method designed to increase the

a clinical trial tests a method designed to increase the probability of conceiving a girl. in the study 290 babies were

  If water is flowing through the pipe with a velocity of 3

a pump is designed to move water and deliver to a vertical distance of 80m what energy per kg of water must be supplied

  Invest money in the stock market or in gold

Based on the expected return, would you rather invest your money in the stock market or in gold? Why?

  An instructor gives his class a set of 13 problems with the

an instructor gives his class a set of 13 problems with the information that the next quiz will consist of a random

  Researchers studied the effects of adding an exercise

researchers studied the effects of adding an exercise program to dieting in the achievement of weight loss. a sample of

  Find the distribution of profit for a unit price

Find the distribution of profit for a unit price of $500. Use the Decision Table tool to find the best price between $400 and $600 in steps of $25.

  The scale of scores on the wais are approximately normal

question wechsler adult intelligence scale wais scoresthe scale of scores on the wais are approximately normal with

  The number of cases of tetanus reported in the us during a

the number of cases of tetanus reported in the u.s. during a single month in 1989 has a poisson distribution with a

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd