Develop side by side box plots for the grouped data

Reference no: EM131231845

1. The Evans Excel file College Data provides data from different colleges and branch campuses within one university over four years.

Calculate descriptive statistics for each of the factors (e.g. Ave ACT, Ave SAT, etc.) for each of the four years of data. Use the Excel Data-Analysis toolpak.

Group the data into Main Campus and Branch Campus. Develop column charts comparing the median for the six factors for the Main Campus and for the Branch Campus.

a. Develop side by side Box Plots for the grouped data (Main and Branch) for each of the factors, i.e. you should have six side-by-side box plots.

b. Write a one paragraph report to the college's vice president explaining the information you developed and stating your conclusions.

2. Using the US Census Population Estimates file, complete the following:

Calculate descriptive statistics for each of the six yearly population estimates.

Using the 2015 population estimates, develop and graph a properly labeled histogram with 10 bins.

Calculate the percentage growth in population from 2010 to 2015 for all states/territories and rank each in comparison to each other.

a. Using the data in the Excel file Cereal Carb Data, develop a probability mass function and cumulative distribution function (both tabular and as charts) for the random variable Carbs.

b. What is the probability that a box of cereal from this population contains less than 7 carbs/serving?

c. Between 10 and 17?

d. More than 20?

4. A study of nonfatal occupational injuries in the United States found that about 31% of all injuries in the service sector involved the back. The National Institute for Occupational Safety and Health (NIOSH) recommended conducting a comprehensive ergonomics assessment of jobs and workstations. In response to this information, Mark Glassmeyer developed a unique ergonomic handcart to help field service engineers be more productive and also to reduce back injuries from lifting parts and equipment during service calls. Using a sample of 286 field service engineers who were provided with these carts,

	YEAR 1 (WITHOUT CART)	YEAR 2 (WITH CART)
Average call time	7.05 hours	7.51 hours
Standard deviation call time	1.30 hours	1.34 hours
Proportion of back injuries	0.02	0.009

Find 99% confidence intervals for the difference in average call times and difference in proportion to back injuries. What conclusions would you reach?

5. An engineer measured the surface finish of 35 parts produced on a lathe, noting the revolutions per minute of the spindle and the type of tool used (see the Excel files Surface Finish). Use ANOVA to test the hypothesis that the mean surface finish is the same for each tool. If the null hypothesis is rejected, apply the Turkey-Kramer multiple comparison procedure to identify significant differences.

6. The Excel file Concert Sales and Ads provides data on sales dollars and the number of radio and TV and newspapers ads promoting the concerts for a group of cities. Develop simple linear regression models for predicting sales as a function of the number of each type of ad. Compare these results to a multiple linear regression model using both independent variables. Examine the residuals of the best model for regression assumptions and possible outliers.

7. For the data in the Excel file Regular Gasoline Prices do the following:

Develop spreadsheet models for forecasting prices using single moving average and single exponential smoothing.

Using MAD, MSE, and MAPE as guidance, find the best number of moving average periods and best smoothing constant for exponential smoothing. Experiment with at least three (3) variations of number of periods and different smoothing constants.

Attachment:- Assignment.xlsx

Reference no: EM131231845

Questions Cloud

Apply managerial accounting concepts : Explain ability to provide general analysis and apply managerial accounting concepts, customer intelligence gathering, forecasting, staff planning, scheduling, analytical and statistical problem solving, financial, accounting, business and budget ana..

What factors influence listening perception and priorities : What factors influence listening perception and priorities? What are their implications for organizational communication?

Discuss design for six sigma principles : Discuss lean manufacturing. discuss design for six sigma principles , also value stream mapping (vsm) there is book pdf format titled learning to see value stream mapping to create a value and eliminate muda. it provide a step by step detail of a cur..

What are the three major trends in dow theory : What are the three major trends in Dow Theory? Which is the most important? Why? -Why did Dow and his followers think that trading with the secondary trend was too risky?

Develop side by side box plots for the grouped data : Develop side by side Box Plots for the grouped data (Main and Branch) for each of the factors, i.e. you should have six side-by-side box plots.

Which president created the u.s. department of labor : The Gay, Lesbian, and Straight Education Network's 2011 National School Climate Survey showed __________ of lesbian, gay, bisexual, and transgendered youth reported feeling unsafe in school due to their sexual orientation.

How dow react to modern day practice of day trading : How would Dow and his followers react to the modern-day practice of day trading? According to Dow Theory, what trend are these day traders following.

Explain what employee empowerment means : Explain what employee empowerment means from both management’s perspective and the employee’s viewpoint. Describe three ways in which a company can motivate its employees. Describe a situation in which you have worked where you felt empowered (or not..

Research about internationalisation : Developing countries like Egypt and Cameroon. I intend to use quantitative methods with the use of questionnaires. I would focus on two research questions and my sample would be selected randomly.

User Account

All Pages