# Need help with my data analysis assignment

Anonymous
account_balance_wallet \$20

Question description

Hello, I need a help with my assignment. This assignment requires Excel and Minitab softwares. Check the the files for the requirements. When you finish, please put the work on a word document. Thank you.

DSCI 2710 CASE ASSIGNMENT 4 Due Dec 13 11:59pm Soda Can Filling in Cola Supreme 1. Introduction Cola Supreme has decided to use control charts to monitor the changes in variability of the output from their 15-ounce filling machine. The production manager randomly selects five cans of cola and measures the amount of cola in each can. The sampling is repeated at 15 successive time periods. 2. The data Bottle filling data are provided in Excel file Case4_ColaSupreme-data.xlsx. The file is posted on Canvas. 3. Line plots for the process range and mean in Excel Using Excel functions =max()-min() and =average(), compute the range and the sample mean for each one of the 15 samples provided in the data set. After computing the ranges and the means for all 15 samples, select the cell range G2:G16 in column G and then select Insert > Insert Line Chart > 2-D Line. This is a line chart for the sample ranges. Similarly, select the cell range H2:H16 in column G and then select Insert > Insert Line Chart > 2-D Line to produce a line chart for the sample means. 4. A control chart for the process range in Minitab Download the data file Case4_ColaSupreme-data.xlsx from Canvas. In the COB computer lab, select the COB Menu (Star Icon) > DSCI > Minitab 17, or COB Menu (Star Icon) > Statistics> Minitab. Let us assume that you saved in in C:\temp. Once Minitab starts, select File > Open > Files of type = Excel > Filename = Case4_ColaSupreme-data.xlsx > Open. The data will appear in the spreadsheet portion (lower portion) of Minitab. In Minitab, select the Stat > Control Charts > Variables Charts for Subgroups > Xbar-R > Observations for a subgroup are in one row of columns: C2-C6 > OK. The two control charts will appear in a separate window. 5. Case quiz on the Blackboard Upload the report to Canvas by the due date. In your report, include the following:  Your name at the top  The following analysis output as described in this handout: Exhibit 1: Line chart of the sample ranges produced in Excel. Exhibit 2: Line chart of the sample means produced in Excel. Exhibit 3: R-chart produced in Minitab. Exhibit 4: Xbar-chart produced in Minitab.  Answers to the following questions: Question 1: Is the process in control with respect to the range? Explain briefly. Question 2: Is the process in control with respect to the mean? Explain briefly.
Period Obs1 Obs2 Obs3 Obs4 Obs5 1 15 14,97 15,01 15 15,04 2 14,96 14,98 14,97 14,95 14,98 3 14,98 14,95 15,02 14,96 14,98 4 15,03 14,98 14,99 15 15,03 5 15,01 14,98 15,04 14,99 15,05 6 14,99 15,01 15,02 14,98 15 7 15,03 15 15,04 14,96 14,97 8 15 15 15,02 15 15,04 9 15 15,03 15,01 14,95 15,01 10 14,97 15,01 14,98 14,96 15,03 11 15,05 15,03 15 14,98 14,96 12 15,01 15 14,97 14,96 14,99 13 15,02 14,98 14,97 14,99 15,03 14 14,99 14,99 14,97 15 14,99 15 14,95 15 14,95 15,03 14,96 Ranges Means

geobalies
School: Cornell University

I have done the best i can with the data provided. here is the suitable solution. please don't forget to add your name as instructed. Also don't forget to drop feedback.Cheers

CASE ASSIGNMENT 4: Soda Can Filling in Cola Supreme
Name:

Period
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

Obs1
15
14.96
14.98
15.03
15.01
14.99
15.03
15
15
14.97
15.05
15.01
15.02
14.99
14.95

Obs2
14.97
14.98
14.95
14.98
14.98
15.01
15
15
15.03
15...

flag Report DMCA
Review

Anonymous
Good stuff. Would use again.

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors