Home Uncategorized Excel project help needed
Uncategorized

Excel project help needed

you can find everything attached

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

EXCELurgentcomputer scienceinformation systems

2

>Twisty’s

0

8

A

2

1

98

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

108
123

1

98

1

110

TWISTY’S PLAYER THEATRE
Your Last Name, First Name Here
Your Red ID # Here
ADVANCE SALES
1 0 8
12
9
11
10
9

6
12

3
13
11

7
11B
126
10C
99
17
129
11D
103
122
127
109
110
12

4
1

16
20
104

J Dillinger

Your Last Name, First Name Here
Your Red ID # Here

0
1
2
3
4
6
7
8
9
10
11
12
13
16
17
20

0
1
2

J DILLINGER’S BANK & TRUST
Withdrawals Bin

Prob Cum Bin
5
14
15
18
19
Women Hyper

Off Road Rage

Your Last Name, First Name Here
Your Red ID # Here

Prob

OFF ROAD RAGE INC.
Miles CumProb
70A
750
800
850
90B
950
1000
1050
1100
1150
1200
1250
130C
1350
1400
1450
1500
1550
160D

Excel Stat Pack 1

TWISTY’S PLAYER’S THEATRE

Measures of Descriptive Statistics

1) Measures of Central Tendency: Mode, Median, Mean

2) Measures of Variability: Sample Standard deviation, Variance,

Range, Skewness, and Inter-quartile Range,

The Facts

Twisty’s Player’s Theater is a local theatre mostly performing avant-garde plays from unheralded playwrights. Twisty’s resident director is dedicated to her art, but the theatre business is a risky business. Thus, for the 135-seat theatre advance sales is highly important.

The Data

Twisty’s has collected the advance sales numbers for the past 30 operating days. The data is located in the Excel Worksheets.

Steps:

1) Open Excel.

2) Pull up Twisty’s Player Theatre data.

3) Select Data Tab from the menu bar and click on Data Analysis.

4) Scroll down and select Descriptive Statistics. Click OK.

5) In the text box for Input Range type: A5:A35. This is the

range of cells the data is located in, including the label.

6

) Grouped by: Columns (Should be the default choice).

7) Click:

Output Range – Type in E5. This will place the upper-left cell of our output at E5.

Summary Statistics.

Labels in the First Row,

Confidence Level for Mean – 95%,

Kth Largest and Smallest — 7

This will give us the approximate values for P75 and P25, the 7th largest and 7th smallest values out of 30 data points. Subtracting the Kth Largest value from the Kth Smallest value will give you the approximate value for the inter-quartile range.

9) Click: OK.

10) Widen Column width so all results are legible.

J. DILLINGER’S BANK & TRUST

Discrete Probability Distributions

1. Binomial Distribution

The Facts

J. Dillinger’s Bank & Trust is a community bank in the town of Hardscrabble, CA. Based upon past experience they know that 35 percent (.35) of the people entering will make a withdrawal. The rest are depositing money, checking accounts, or performing loan transactions. Suppose 20 people enter the bank. What is the probability that 10 people make a withdrawal? That less than 3 make a withdrawal?

These questions can be answered using the binomial distribution.

Note: There are NO “lettered cells” for this example.

Steps:

1) Pull up J Dillinger’s Bank & Trust data.

2) Place cursor on cell B6, and using the function wizard (
fx
)

select BINOMDIST.

3) In the first text box Type: A6.

4) For trials Type: 20.

5) For probability Type: .35

6) For cumulative Type: False. (Or input zero.) And click OK.

7) The result is for the probability no one will make a

withdrawal. Click and drag to calculate the probabilities for

1-20 people making withdrawals.

Note: Some cells may contain “E-#” which is scientific notion meaning the decimal point is really “#” places to the left for the number in the cell. Excel does this because the cell is not wide enough. You can leave it as is.

8) To calculate the Cumulative Binomial, rather than individual probabilities, place the cursor in cell D6. Follow the above steps, only Type TRUE (or input the number 1) in step 7.

As you the number of trials approaches 20 the cumulative probability will approach 1 (100%).

2. Hypergeometric

Suppose 12 employees at J. Dillinger’s applied for the 2 open positions of loan officer, eight applicants being women. Assuming all 12 were qualified, what is the probability no women were promoted to loan officer? One woman?

Steps:

1) Place the cursor cell B31.

2) Using the function wizard (
fx
) select HYPGEOMDIST

3) Dialog box inputs:

Sample_s (1st box) -– A31

Number_sample (2d box) — 2

Population_s (3d box) — 8

Number_pop (4th box) –- 12

Some versions will have a fifth input box:

Cumulative –- False (Noncumulative)

4) Click and drag the formula to fill in cells B32 and B33.

OFF ROAD RAGE, INC.

The Normal Distribution

The Facts

Off Road Rage Inc. manufactures mountain bike tires. The average life of their tires is 1,150 miles with a standard deviation of 150 miles. What percentage of their tires will wear out before 950 miles [P (X < 950)]? What percentage of tires will last more than 1300 miles [P (X > 1300)]?

Steps:

1) Pull up the Off Road Rage Inc. data.

2) Select cell B6. Then using the function wizard (
fx
) select

NORMDIST. (Do not select NORMSDIST which is for the standard normal

distribution (mean = 0, std. = 1).

3) Fill in the text boxes as follows:

X — A6 (location of first value).

Mean — 1150

Std — 150

Cumulative — False

4) Click and drag to obtain the probabilities for the data set.

5) To obtain the cumulative probabilities repeat the above steps,

except Type: True instead of False. Click and drag to obtain

the probabilities for the complete set. Again, the cumulative

probability will approach 1 (100%) near the end of the column.

Graphing Results

1) Select cells B6: B24.

2) Click the
Insert Tab from toolbar.

3) Select Area (Chart type)

4) Select the first picture icon under 2-D Area.

Note: Your chart should closely resemble a normal distribution.

5) To graph the cumulative Probabilities select cells C6:C24.

6) Click the Insert Tab from the toolbar.

7) Select Area.

8) Select the first picture icon under 2-D Area

Note: Your chart should be upward sloping, flatting out near 1 (100%)

9) Label your chart to help the reader understand it.

10) Move both charts to the right of your data, if you are going to print them on the same sheet. Otherwise print them on a separate page.

GRAPHICS

Done well, tables and graphs are useful and effective tools in telling a story, trying to convince others of a position, and/or explaining a phenomenon. Done poorly and graphs can be confusing and misleading.

Creating Tables and Graphs using the Raw Survey Results page —

A. Creating Table CATEGORIES

1) Copy and Paste the Major data (Column A) to a new page.

2) Select Data Tab, Filter Advanced. Dialog box inputs:

•Select Copy to a New Location

•List Range: the column of data you copied & pasted, including

the heading (Major) (Ex: Sheet1!$A$1:$A$75)

•Copy to: input any open cell on the page (Ex: Cell D1)

•Select Unique Records Only (Leave Criteria Range blank)

3) You should now have a new list of all the majors (Categories)

B. Creating table FREQUENCIES

4) Type “No. of Students” in the cell to right of the new heading

“Major” (Ex: Cell E1)

5) Put the cursor in the cell below “No. of Students” (Ex: Cell E2)

6) Select the
fx icon and choose COUNTIF. Dialog box inputs:

•Range: the column of raw survey data you copied & pasted,

NOT including the heading MAJOR (Ex: A2:A75)

•Criteria: Your newly created list of majors (NOT including the

heading MAJOR) (Ex: D2:D7)

•In the formula bar where you see the COUNTIF formula being written,

highlight the cells and hit the F4 key*. Click OK.

•Drag the formula to fill in the frequency counts for each major

•You should now have a summary data table similar to those on the

Summary Data Tables page of the Class Survey workbook.

7) Copy & Paste your table anywhere else on the page but when you paste

choose Paste Values.**

•DELETE the raw survey data and original table.

C. Creating a Chart

8) Highlight your data, select Insert, and choose an appropriate chart.

See Graphs of Summary Data page for examples.

*The F4 key will place dollar signs before the cell letter and number (A2 will become $A$2), thus “locking” them. That is, the formula will reference cell A2 even though it is dragged into other cells. If your F4 key does not place $ into the cell, do it manually. In the formula bar you should see something like: =COUNTIF($A$2:$A$75,$D$2:$D$7).

**If you do not copy & paste the table (using PASTE VALUES), when you delete the raw survey data the cells in the table will show the #REF! error rather than the values, as the formulas in the table reference

the original, raw data.

C. Campus Engagement: Table & Graph

1) Using the Campus Engagement data (Column B from the Raw Survey

Results page) and steps similar to the previous example create a

table and graph.

2) Choose an appropriate graph style that is different from the one you

created for the Major data.

Tables & Graphs: clean up all tables and all graphs, labeling, titling, appropriate axis, and setting them properly within the document.

For the Student Majors and Campus Engagement exercise turn in the tables and their corresponding graphs only. You can arrange the two tables and two graphs onto one page.

Note: Tables and graphs can also be created using the PIVOT TABLE function under the INSERT tab.

END NOTE:

Turn in one copy of you work. FULL POINTS requires all pages to be (A) in the same order as given in the Fact Set and (B) formatted as directed in the Mandatory Standards document contained in the Read First! file.

6

2

>Raw Class Survey Data

. of Units

2

.

No

Yes

5 4 4

4 5 3 4 4 4 2 2

.

Off campus Full-time No No Yes Female 3 4 4 2 4 3 5 4 3 3 4 4 20 4

Fraternity/Sorority

10

Full-time Yes Yes Yes

5 5 3 3 4 3 4 5 4 4 1 1 20

2

SDSU Sports Team

0 8

Off campus Full-time No Yes Yes Female 4 4 4 3 4 3 4 4 4 5 1 1 20

5

General Business/Management

0.5 Off campus Full-time No Yes Yes Male 3 4 4 2 5 4 5 4 4 4 1 1 20

General Business/Management No Affiliation

0 8 0.25 Off campus Full-time No No Yes Male 4 4 5 5 5 5 3 5 4 4 5 5 20

General Business/Management Fraternity/Sorority

0 6 1 On campus Full-time No Yes Yes Female 4 5 5 3 5 4 4 4 3 4 3 4

9

Accounting Fraternity/Sorority 15 0 7 0 On campus Full-time No Yes Yes Male 4 5 4 3 4 4 5 5 4 4 1 1

3.4

Accounting No Affiliation 16 10 7.5 1 Off campus Full-time Yes No Yes Male 3 3 4 2 4 3 4 4 4 3 1 1 21

Accounting

16 0 8 7 Off campus Full-time No Yes No Male 5 5 5 3 5 5 3 4 5 4 5 5 19

7

Accounting No Affiliation

1 Off campus Full-time Yes Yes No Male 3 4 5 5 5 4 5 4 4 2 2 1

3.1

Marketing SDSU Club

0

0.5 On campus Full-time No Yes Yes Female 4 4 3 4 3 4 5 4 3 3 2 1 19

Marketing SDSU Club 16

7.5

On campus Full-time No Yes Yes Male 3 5 5 3 5 4 5 4 5 5 1 1 19

Marketing No Affiliation 16 0 9 0.25 Off campus Full-time No No Yes Male 5 5 4 3 4 5 4 4 4 5 2 2 20 2.9
Accounting No Affiliation 15 15 6 1 Off campus Full-time No Yes No Male 3 3 2 4 4 3 5 3 2 4 1 3

2.9

Accounting No Affiliation 15 20 4.5 2 Off campus Full-time Yes Yes Yes Female 3 4 5 4 5 5 5 3 1 5 5 5 20

Marketing SDSU Club 18 15 8 1 Off campus Full-time No Yes Yes Female 3 4 4 2 4 4 4 2 2 4 2 3 21 3.45

No Affiliation 12 0 6 1 Off campus Full-time Yes Yes No Male 2 4 5 2 5 5 2 5 5 3 1 1

General Business/Management No Affiliation 9 18 7 1 Off campus

No Yes Yes Female 4 5 4 3 5 5 3 4 3 4 3 3 25 2.9

General Business/Management No Affiliation 16 0

2.5 On campus Full-time No Yes Yes Female 3 5 5 3 5 5 5 5 3 5 4 4 20

Accounting No Affiliation 13 20 6.5 2 Off campus Full-time Yes Yes Yes Female 2 1 4 4 3 5 5 4 2 5 5 4 20 3.4
Entrepreneurship Fraternity/Sorority 13 0 8 0 On campus Full-time No No Yes Male 4 5 4 2 5 5 2 3 4 4 1 1 20

1

Marketing Fraternity/Sorority 17 12 8 1 Off campus Full-time No No Yes Female 4 4 4 2 4 4 5 3 2 5 1 1 21 3.3
Accounting No Affiliation 16 0 8 25 Off campus Full-time Yes Yes Yes Male 1 4 4 5 4 5 5 4 4 4 1 1

Accounting SDSU Club 18 24 8 2 Off campus Full-time No Yes Yes Male 4 2 5 3 5 5 3 4 4 5 4 5 20

Accounting No Affiliation

0 6 5 Off campus Full-time No Yes Yes Male 4 4 3 2 4 4 3 3 3 4 5 5 20

Accounting No Affiliation 15 30

1.5 Off campus Full-time Yes Yes No Male 1 2 5 3 4 5 5 4 5 3 4 2 20 3.5

Accounting SDSU Club 16 24 7 1.5 Off campus Full-time Yes Yes Yes Female 3 5 5 2 5 4 5 4 5 5 3 1 24 2.9
Accounting SDSU Club 15 0 6 1 Off campus Full-time No Yes No Male 1 2 3 3 4 3 5 4 2 4 1 1 21

Marketing No Affiliation 14 24 8 1 Off campus Full-time Yes Yes Yes Female 3 5 5 3 5 5 5 5 4 4 4 1 21 3.6
Information Systems SDSU Sports Team 15 0 6 0.5 Off campus Full-time No Yes Yes Male 4 4 4 5 4 5 4 3 2 3 1 1 20

Information Systems No Affiliation 16 20 8

Off campus Full-time No Yes Yes Male 5 5 5 4 4 4 5 5 5 4 2 1 21

Accounting SDSU Club 18 10 7 1 Off campus Full-time No Yes Yes Male 3 3 4 4 5 4 5 4 4 4 1 1

Information Systems No Affiliation 15 36 7

Off campus Full-time Yes Yes Yes Male 4 4 4 5 5 4 4 5 3 3 1 1 21

General Business/Management SDSU Club 16 10 8 0.25 Off campus Full-time No Yes Yes Male 2 4 4 3 5 5 3 4 3 5 2 2 20 2.9
General Business/Management No Affiliation 13 0 8 1.5 Off campus Full-time No Yes Yes Male 4 5 5 2 5 5 5 4 4 5 2 3 30 3.7
Entrepreneurship No Affiliation 15

5 1 On campus Full-time No No Yes Female 5 5 5 3 5 3 5 4 2 5 1 3 19

General Business/Management No Affiliation 15 8.5 8.5 2 Off campus Full-time No No No Female 1 4 4 5 4 5 5 3 4 5 1 2 21 2.9
Accounting SDSU Club 15 40 6.5 2.5 Off campus Full-time Yes Yes No Male 5 5 5 3 5 5 3 5 5 5 1 1 24

Information Systems No Affiliation 15 25 7 0.5 Off campus Full-time No No Yes Male 3 3 4 5 5 4 5 2 3 4 2 1 21 3.2
Marketing Fraternity/Sorority 13 16 8 1 On campus Full-time No Yes Yes Male 3 4 5 3 3 4 4 4 3 4 1 1 19

SDSU Club 16 0

Off campus Full-time No No No Female 1 1 3 5 2 3 2 5 5 5 5 4 21 3.7

Marketing Fraternity/Sorority 16 20 8 1.25 Off campus Full-time No Yes Yes Female 4 5 3 3 4 3 4 2 2 4 2 3 19 3.1
Information Systems No Affiliation 15 0 7.25 0.75 Off campus Full-time No No Yes Male 3 3 4 5 4 4 3 4 3 3 2 2 20

Accounting SDSU Club 15

7.5 1.5 Off campus Full-time Yes Yes Yes Male 4 3 4 3 4 3 5 4 4 3 1 1 20

Accounting No Affiliation 17 0 7.5 0.5 Off campus Full-time No Yes Yes Male 3 3 3 4 4 4 4 4 3 2 3 2 20 3
Information Systems No Affiliation 15 0 8 0.25 Off campus Full-time No No Yes Male 4 4 4 5 3 5 1 4 4 3 1 1 21

Accounting Fraternity/Sorority 15 0 7 0.25 Off campus Full-time No Yes Yes Male 3 4 4 2 4 5 4 3 4 4 3 3 21

Marketing Fraternity/Sorority 17 24 8 1 Off campus Full-time No Yes No Female 2 5 4 3 5 4 5 3 3 4 2 4 20 2.9
Accounting Fraternity/Sorority 17 0 7.5 0 On campus Full-time No No No Male 4 3 4 3 5 5 5 3 4 5 4 4 20 3.3
Accounting No Affiliation 18 22 7.25 1.75 Off campus Full-time Yes Yes Yes Male 5 4 4 2 4 4 5 5 3 2 2 3 19 3.9
Marketing Fraternity/Sorority 15 4 8 1 On campus Full-time No Yes Yes Female 4 4 4 3 3 3 4 4 3 5 1 1 21 3
Accounting No Affiliation 15 20 6.5 0.5 Off campus Full-time No Yes Yes Female 2 2 4 5 4 4 5 3 2 5 5 5 21 3
Accounting Fraternity/Sorority 12 25 6.5 0.5 On campus Full-time Yes Yes No Male 3 4 5 2 5 4 5 4 4 4 1 2 20

Entrepreneurship SDSU Club 17 0 6.5 0 On campus Full-time No Yes Yes Female 3 4 3 5 4 3 5 3 2 4 2 1 19 3.4
Accounting No Affiliation 12 20 7 0.25 On campus Full-time Yes Yes Yes Female 3 4 4 4 4 5 4 3 3 5 4 4 21

Accounting SDSU Club 13 20 6 0.5 On campus Full-time Yes Yes No Male 3 4 4 3 5 4 4 4 5 3 1 1 19

Marketing No Affiliation 13 15 7 1 Off campus Full-time Yes Yes No Male 4 4 4 4 4 5 5 4 3 4 1 1 21

Accounting No Affiliation 18 15 6 2 Off campus Full-time No No Yes Male 4 3 4 5 4 3 5 3 2 4 2 3 20 3.2
Accounting SDSU Club 12 0 7

Off campus Full-time No Yes Yes Male 4 4 4 5 3 5 4 3 4 3 1 1

3

General Business/Management SDSU Club 15 10 6 2.5 Off campus Full-time No Yes No Male 4 5 4 3 5 4 5 4 4 3 5 5 21

General Business/Management No Affiliation 15 0 8 1 Off campus Full-time No No No Male 3 5 5 3 4 5 4 5 5 5 2 4 20 3.6
Accounting No Affiliation 14 0 7 1 Off campus Full-time No Yes No Male 3 5 4 3 4 5 5 4 4 5 3 1

2.9

General Business/Management No Affiliation 14 30 6.5 1.25 Off campus Full-time No Yes No Male 5 4 5 2 5 5 5 4 3 3 3 4 23 3.2
Accounting No Affiliation 13 0 5 2.5 Off campus Full-time Yes Yes No Female 5 5 5 3 4 5 3 5 3 5 2 2 33 3.93
General Business/Management SDSU Club 16 0 8 0 On campus Full-time No No Yes Male 3 4 3 3 4 4 4 3 2 3 2 2 19 3.66
Entrepreneurship No Affiliation 13 24 6 1 Off campus Full-time No No Yes Male 2 3 4 3 4 4 5 3 4 1 3 2 21 3.6
General Business/Management No Affiliation 18 40 6.5 0.5 Off campus Full-time Yes Yes No Male 3 5 5 2 5 4 5 4 4 4 2 1 22 3.4
Accounting SDSU Club 15 20 8

Off campus Full-time No Yes Yes Female 3 5 4 3 4 5 4 4 5 5 4 1 21 3.7

General Business/Management No Affiliation 15 20 6 2 Off campus Full-time No No No Male 3 3 4 3 5 4 3 4 3 3 2 3 20 3.5
Accounting SDSU Club 15 21 6 0.25 Off campus Full-time Yes Yes Yes Male 2 3 4 5 3 3 5 2 2 2 1 1 21 2.9
Accounting SDSU Club 16 20 6 0.75 On campus Full-time Yes No No Female 3 4 4 4 5 5 4 3 1 4 1 1 19 3.31
Entrepreneurship SDSU Club 18 25 6 0.5 On campus Full-time No No No Male 3 5 4 4 5 4 5 5 4 5 2 1 20

Marketing Fraternity/Sorority 13 28 7 1 Off campus Full-time No No Yes Male 4 4 4 2 3 3 5 4 4 4 1 1 20 3.2
General Business/Management No Affiliation 15 10 7 0.75 Off campus Full-time No Yes Yes Male 4 5 5 3 5 5 4 3 3 5 5 5 21

General Business/Management No Affiliation 20 6 6 2 Off campus Full-time No Yes Yes Male 4 5 5 5 5 5 5 1 3 4 4 4 21

Accounting No Affiliation 15

7.25 1.25 Off campus Full-time No No No Male 3 3 3 4 3 3 4 3 2 3 2 2 21 3

General Business/Management No Affiliation 17

5.25 On campus Full-time Yes No No Male 2 3 4 1 4 3 3 3 2 4 1 1 19

Accounting No Affiliation 12 10 7 1 Off campus Full-time No Yes Yes Male 4 5 4 3 4 5 4 3 4 3 4 3 24 3.8
Information Systems No Affiliation 15 0 7 0.25 Off campus Full-time Yes Yes No Male 5 5 5 2 5 5 3 4 5 5 4 3 21

Accounting Fraternity/Sorority 13 0 7.25 0.5 Off campus Full-time No Yes No Female 2 3 4 4 3 3 5 4 2 4 1 1 21

Marketing No Affiliation 7

8 1 Off campus Full-time No Yes Yes Female 1 5 5 3 5 4 5 3 3 4 5 5 22 2.5

General Business/Management No Affiliation 16 0 8 4 Off campus Full-time No No Yes Male 5 5 5 1 4 4 5 3 4 5 5 5 20

Marketing No Affiliation 16 8 6.5 0.75 Off campus Full-time No Yes Yes Male 3 4 5 3 5 3 5 4 5 3 2 2 22

Accounting No Affiliation 16 15 7 1 Off campus Full-time No No No Female 2 3 3 4 4 5 4 4 3 3 2 2 24 3.6
Marketing SDSU Club 14 20 8 0.5 Off campus Full-time Yes No No Female 4 3 4 4 5 4 3 1 2 4 2 3 19

Accounting No Affiliation 15 22 7 2 Off campus Full-time Yes Yes No Male 4 4 5 3 4 5 5 4 4 4 3 1 33

Information Systems No Affiliation 15 20 8

Off campus Full-time No Yes Yes Female 3 5 5 3 5 4 4 4 4 5 5 5 21

Accounting No Affiliation 12

.5

1 Off campus Full-time No No Yes Male 3 3 3 4 3 4 5 4 4 3 1 1 24 2.91

Accounting No Affiliation 13 0 7 0.5 On campus Full-time No No Yes Male 5 4 4 5 4 3 4 2 3 3 2 1 20 3.65
Entrepreneurship No Affiliation 19 0 5 2 Off campus Full-time Yes Yes No Male 4 3 3 2 2 2 3 2 2 2 3 3

3

General Business/Management SDSU Club 17 30 6 1.5 Off campus Full-time No Yes Yes Female 5 5 5 3 5 4 3 3 2 4 1 1 20 3.8
Accounting No Affiliation 15 12 7 0.5 On campus Full-time No No No Female 4 3 5 4 5 4 5 4 3 4 1 1 20 3.3
Accounting No Affiliation 12 24 8 1 Off campus Full-time No Yes No Male 2 4 4 4 4 4 4 5 4 4 4 4 23 3.2
Marketing Fraternity/Sorority 12 0 7 0 On campus Full-time No No Yes Female 5 5 5 3 5 5 4 4 4 5 2 3 20 2.91
Marketing Fraternity/Sorority 17 20 6 2 Off campus Full-time No Yes Yes Female 3 4 4 2 5 4 5 3 1 4 4 4 20 3.3
Accounting No Affiliation 15 0 7 3 Off campus Full-time No Yes No Male 3 4 4 3 4 5 3 5 5 5 2 2 21 3.17
Accounting No Affiliation 15

6.5 0.75 Off campus Full-time Yes Yes No Female 3 3 4 4 5 3 5 4 4 3 1 1

Accounting No Affiliation 12 18 7 1 Off campus Full-time Yes Yes Yes Female 3 3 4 4 4 3 5 4 4 2 1 1 22 2.98
Accounting No Affiliation 9 20 8 4.5 Off campus Part-time Yes Yes No Male 1 3 5 3 5 5 5 1 5 5 5 5 24

General Business/Management No Affiliation 13 20 6 1 Off campus Full-time No No Yes Female 3 3 4 4 3 5 3 4 4 4 3 3 22 3.1
Accounting No Affiliation 14 0 7.5 0.5 Off campus Full-time Yes No No Male 4 4 4 4 5 4 5 3 4 5 1 1 22

Information Systems No Affiliation 18

7.25 0.75 Off campus Full-time Yes Yes No Male 4 4 4 4 4 4 4 4 4 4 2 1 24 3

Information Systems No Affiliation 15 20 7 1 Off campus Full-time No Yes Yes Male 5 4 4 3 4 4 5 4 4 5 1 1 23

Accounting No Affiliation 16 0 6 3.5 Off campus Full-time No Yes No Male 4 4 5 4 5 5 5 3 5 5 5 4 21 3.7
Accounting No Affiliation 10 30 7.5 3 Off campus Full-time Yes Yes No Female 3 3 4 3 4 4 5 3 3 2 3 2 22 3.45
Accounting SDSU Club 16 0 3.5 1 Off campus Full-time Yes Yes Yes Male 5 3 3 5 5 5 5 3 2 4 3 4 21 3.7
Other No Affiliation 12 0 7 0.25 On campus Part-time Yes Yes Yes Male 4 5 5 4 5 4 3 4 4 5 2 1 21 3.57
Marketing No Affiliation 16 20 7 0.5 On campus Full-time No Yes Yes Female 5 5 5 2 5 5 4 5 5 5 5 5 19

Marketing No Affiliation 18

1 Off campus Full-time No No Yes Female 4 4 5 1 4 5 2 3 4 4 3 2 21 3.7

General Business/Management No Affiliation 12 20 7 2 Off campus Full-time Yes Yes No Male 2 3 4 3 4 4 3 4 3 4 2 2 29

General Business/Management No Affiliation 12 30 6.5

Off campus Full-time Yes Yes No Male 4 5 5 3 4 5 4 4 4 5 2 1 23 3

Accounting SDSU Club 12

6.25 0.45 Off campus Full-time Yes No No Female 3 3 4 4 5 5 5 5 5 5 5 3 24 3.3

Accounting SDSU Club 18 0 7 0.25 Off campus Full-time No Yes Yes Male 4 3 4 3 5 4 5 4 4 5 3 3 21

Accounting SDSU Club 12 10 7 1 Off campus Full-time No Yes No Male 4 5 4 3 4 5 3 4 4 4 4 4 26

Marketing No Affiliation 11 10 8 1 Off campus Part-time Yes No Yes Male 2 3 4 4 3 4 4 3 3 3 2 3 23 3.2
Accounting SDSU Club 15

7.25 0.25 On campus Full-time No Yes Yes Female 4 4 4 4 4 3 4 2 4 4 5 5 20 3.57

Marketing SDSU Club 13 0 6 1.25 Off campus Full-time Yes Yes Yes Male 3 4 4 3 4 4 4 3 3 4 3 4 21

Marketing Fraternity/Sorority 15 0 7 0.25 Off campus Full-time No No Yes Male 3 5 4 3 3 4 4 2 4 4 2 2 20 3.06
Accounting No Affiliation 15 18 7 1 Off campus Full-time No No Yes Female 3 3 4 3 4 4 4 3 3 4 4 4 21 3.8
Accounting No Affiliation 15 21 5 4 Off campus Full-time Yes Yes No Female 3 4 4 4 4 4 5 4 3 3 3 3 22 2.9
Accounting No Affiliation 15 0 8 1 Off campus Full-time No Yes No Female 5 5 5 1 5 5 5 5 5 5 3 3 21

Accounting No Affiliation 15 24 7 0.25 Off campus Full-time No No Yes Female 4 4 3 1 4 3 5 4 1 4 1 2 21 3.06
Accounting SDSU Club 15 0 5.25 2 Off campus Full-time Yes No Yes Female 3 4 4 3 4 4 5 4 3 5 1 1

Marketing No Affiliation 17 10 8 0.5 Off campus Full-time No No Yes Male 3 3 4 4 3 4 4 3 4 3 3 3 22 3.4
Marketing No Affiliation 12 30

Off campus Full-time Yes Yes Yes Male 3 4 3 5 3 4 3 4 4 4 2 1 27 2.5

Information Systems Fraternity/Sorority 16 10 9 20 On campus Full-time No No Yes Male 3 4 5 5 5 5 4 5 4 5 5 3 21 3.2
Accounting No Affiliation 18 20 7 1.5 Off campus Full-time Yes Yes No Female 4 5 4 4 5 5 4 3 3 4 2 2 25 3.93
Accounting No Affiliation 15 0 7 0.75 Off campus Full-time Yes Yes Yes Male 4 4 4 3 3 4 5 4 4 4 4 3 26 3.4
General Business/Management No Affiliation 12 20 6.5 2 Off campus Full-time Yes Yes No Male 2 4 4 3 4 4 3 4 3 4 3 2 29 2.02
Accounting No Affiliation 12

5 3 Off campus Full-time Yes No No Female 3 5 3 3 5 5 4 3 3 3 4 4 25 3

Accounting No Affiliation 15 20 6 0.5 Off campus Full-time No No No Female 4 5 5 2 4 5 5 3 5 4 4 4 28

Major Campus Engagement No Work Hours per Week Sleep per night Daily Commute Time Residency Locale Enrollment Status Self-Sufficiency Known Work Prospect Parent(s) With Collegee Degree Gender Last Semester Rating Happy with Major? Persistency Procrastination Goal Orientated This Semester Rating College Stress Level Easily Adaptive Control Negativity Easily Build Relations Prayer/Mediation Religious/Spirituality Age GPA
Marketing Fraternity/Sorority 1 0 9 4 5 Off campus Full-time Yes Female 3 21 3.1
General Business/Management SDSU Sports Team 1

 8 20 6 25 2.5
Entrepreneurship 1

 7 10 0.25 On campus Male 2.9
Accounting 16 0.5 3.4
No Affiliation 15 1

 7.5 8.5 3.5
13 2.99
14 19 3.7
18
3.3
SDSU Club 3.8
12 48 4.5 24
17 6.75 3.6
30 1.5 3.45
22
3.46
Information Systems 35 3.67
Part-time
6.5 3.63
3.9
28 2.91
3.66
26 2.79
7.25
3.

36
3.2
1.25 3.

 33
34 3.48
1.75 3.57
40 3.93
3.95
3.65
Other 5.5 0.75
3.

37
3

 5.25 3.84
3.24
3.13
2.92
2.98
3.31
3.17
0.45 29
3.56
23
50
2.85
3.06
3.03
13.5
20.25 6.25 3.51
3.42
3.72
32
3.88
3.16
3.87
2.88
0.15 3.04
27 5.75
44
22.5 41 3.99
1.9
3.58
50.75
3.

 11
3.75
12.25 9.5
2.02
2.15
19.25
3.19
3.02
9.75
2.36
3.74
39 3.82
4.75 4.25
24 hours
3.28

Sheet1

Examples of Table & Graphs For Generic Class, Not Your Specific Section. Displayed solely for example purposes.

Female, Male Data

4 5 3 4
4 4 5 5
4 4 4 3
5 5 4 5
4 3 5 4
4 5 5 3
4 4 4 5
5 5 3 5
5 5 5 4
1 3 5 5
4 4 5 2
5 5 5 2
5 4 5 5
5 2 5 3
4 4 5 3
1 2 2 5
5 2 4 5
5 4 5 4
4 5 4 5
2 3 5 5
4 4 5 4

4 4 4 3
5 5 3 5

5 5 4 3
4 3 4 5
3 4 5 4
5 3 5 3
3 3 4 5
3 3 3 4
5 4 4 1
5 4 3 4
3 3 5 5
5 4 4 5

4 4 5 5
3 4 5 4

3 4 5 5
3 3 3 5

3 4 5 4
5 5 4 5

4 5 2 4
3 5 5 5

4 4 4 5

3 4 4 4
4 3 5 5
5 5 5 5
4 3 5 3

4 3 5 5
5 5 4 5
5 4 4 5
5 5 5 4

5 5
3 4
3 3
5 4
5 3

5 5

4 5

4 5

3 5
4 4

3 3
4 4

4 3

3 5
4 5
4 4
4 5
4 5
3 5
5 3
3 3
5 4
3 5
5 3
3 4
4 4
5 4
3 4
4 3
4 4
4 5
4 3

Happy w/ Major, Female Happy w/ Major, Male College Stress Level, Female College Stress Level, Male

Dummy Variables

Known Work Prospect Self-Sufficiency Parent(s) With Collegee Degree

1 0 1

0 0 1

1 1 1
1 0 1

1 0 1

0 0 1

1 0 1
1 0 1

0 1 1
1 0 0
1 1 0

1 0 1
1 0 1
0 0 1
1 0 0
1 1 1
1 0 1
1 1 0
1 0 1
1 0 1
1 1 1
0 0 1
0 0 1
1 1 1
1 0 1
1 0 1
1 1 0
1 1 1
1 0 0
1 1 1
1 0 1
1 0 1
1 0 1
1 1 1
1 0 1
1 0 1
0 0 1

0 0 0

1 1 0
0 0 1
1 0 1
0 0 0
1 0 1
0 0 1
1 1 1
1 0 1
0 0 1
1 0 1
1 0 0
0 0 0
1 1 1
1 0 1
1 0 1
1 1 0
1 0 1
1 1 1
1 1 0
1 1 0
0 0 1
1 0 1
1 0 0
0 0 0
1 0 0
1 0 0
1 1 0
0 0 1
0 0 1
1 1 0
1 0 1
0 0 0
1 1 1

0 1 0

0 0 0
0 0 1
1 0 1
1 0 1
0 0 0
0 1 0
1 0 1
1 1 0
1 0 0
1 0 1
0 0 1
1 0 1
0 0 0
0 1 0
1 1 0
1 0 1
0 0 1
0 0 1
1 1 0
1 0 1
0 0 0
1 0 0
0 0 1
1 0 1
1 0 0
1 1 0
1 1 1
1 1 0
0 0 1
0 1 0
1 1 0
1 0 1
1 0 0
1 1 0
1 1 1
1 1 1
1 0 1
0 0 1
1 1 0
1 1 0
0 1 0
1 0 1
1 0 0
0 1 1
1 0 1
1 1 1
0 0 1
0 0 1
1 1 0
1 0 0
0 0 1
0 1 1
0 0 1
1 1 1
0 0 1
1 1 0
1 1 1
1 1 0
0 1 0
0 0 0

For All Data Sets
1 = Yes
2 = No

Chi Square Data

Female 25 2 7 1 14

Male 37 5 17 11 11

Grand Total

7 24 12 25

Acct Entpnr Gen Bus/Mgt Info Systems Mkting Grand Total
49
81
62 130

INTRODUCTION TO EXCEL STAT PACKS

The Stat Packs are meant to supplement and broaden your understanding of statistics.
Software can ease many of the necessary calculations, it is not, however, a replacement for
statistical knowledge.

All directions are given under the assumptions that students will be using Excel on a Microsoft
device. All analysis will involve either the DATA ANALYSIS TOOL or STATISTICAL FUNCTIONS.
ONCE IN EXCEL:

 To access STATISTICAL FUNCTION click on the Function Wizard icon, fx, located on the
toolbar, to the immediate left of the input line.

 To access the DATA ANYLSIS TOOL click DATA TAB on the toolbar. Data Analysis is
available under the Analysis Group (far right corner of the Tool Bar.)

If you do not see Data Analysis you will need to load it into Excel. It is free. The following
applies to Excel 2007, Excel 2010, Excel 2013, and Excel 2016.

1. Click the File tab, click Options, and click the Add-Ins category. If you’re using Excel 2007,
click the Microsoft Office Button, and then click Excel Options

2. In the Manage box select Excel Add-ins, click Go.

3. In the Add-Ins box, check the Analysis ToolPak check box, click OK.

• If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.

• If you are prompted that the Analysis ToolPak is not currently installed on your
computer, click Yes to install it.

The Data Analysis should now be loaded into Excel.

MAC USERS: Many Excel versions for MAC do NOT have the Data Analysis. If this is the case for
you and you cannot load it into your version, complete those sections requiring Data Analysis
on another computer (such as those in the library).

MANDATORY STANDARDS FOR ALL EXCEL STAT PACKS

Consult This Document for All Excel Stat Packs.

COMPLETING:

1. Follow directions given in individual Excel Stat Packs.

2. Where indicated put your name in the marked cells, copying over the words Last Name, First Name.

3. Where indicated put your Red ID# in the marked cells, copying over the words Red ID#.

4. In YELLOW HIGHLIGHTED EXCEL CELLS substitute the last four digits of your Red ID # for the letters A,
B, C, and D. A student with the Red ID # 888887654 would make the following substitutions: A = 7, B =
6, C = 5, D = 4. Thus, the Twisty Player’s Theatre problem for this student would contain the following
values: (A) Cell A9 = 117 (B) Cell A16 = 116 (C) Cell A20 = 105 (D) Cell A24 = 114

5. Pop-Up Boxes: At times Excel’s input requirements\wording is slightly different across various Excel
versions. If your pop-up box does not match the directions use the help function and good judgement.

FORMATTING:

6. Format your work so it is clean and business like.

7. Do not write anything in pen, pencil, or highlighter, except signature & date in pen if required.

8. Format all graphs and tables, including but not limited to axis titles, scales, data legends, data labels,
and titles, adjusting Excel’s default response settings where deficient.

9. No gridlines.*
10. No Excel row and column headings.*
11. No cutting off words in cells.*
12. Not cutting off tables by the right margin, leaving partial table columns “floating” on the next page.*

13. Keep the “lettered cells” (from #4, above) either highlighted yellow or grey scale when printing.

*Before printing, use Print Preview/Page Setup (if given the option or in the document itself), Portrait
Orientation and/or the NO SCALING options so your stat pack is clean and business-like.

SUBMITTING:

14. Turn it in on time.
15. Turn in a paper copy (no email submissions).
16. Organize papers in the same order as examples are presented in the Excel file.
17. Staple papers together. No loose submissions or paper clips.
18. Do not attach your own cover sheet or use a plastic presentation cover..

Hire a Writer
Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.
Order Now Order Now

Order your essay today and save 30% with the discount code ESSAYHELP

Order Now