PLEASE!! NO RESPONSES UNTIL YOU HAVE READ THE ENTIRE DOCUMENT!!

profilebjsith
excel_charts_week_5.xlsx

Sheet4

Bin Frequency
1 3
1 0
1 0
1 0
1 0
1 0
1 0
1 0
1 0
1 0
1 0
1 0
1 0
1 0
1 0
1 0
2 11
2 0
2 0
2 0
2 0
2 0
2 0
2 0
3 10
3 0
3 0
3 0
3 0
3 0
3 0
3 0
3 0
3 0
4 7
4 0
4 0
4 0
4 0
4 0
4 0
4 0
4 0
5 7
5 0
5 0
5 0
5 0
5 0
5 0
More 12

Sample

FREQUENCY
nog839: nog839: times visited starbucks
EXPERIENCE
nog839: nog839: visit rating
Income Frequency Percentage
7 5 High 15 15
5 3 Medium 25 25
3 2 Low 10 10
4 4 50 50
4 5
2 1
3 1
5 1
4 2
5 3
6 4
2 2
2 2
3 3
2 1
7 1
6 1
7 1
5 3
3 3
5 2
4 1
3 1
2 1
2 3
2 1
6 4
7 2
3 3
2 4
2 4
4 4
3 3
1 3
3 2
5 1
7 1
6 1
2 4
3 5
4 5
1 5
2 5
6 4
7 3
5 2
6 1
3 1
1 5
4 4

Descriptive

Descriptive Statistics FREQUENCY
nog839: nog839: times visited starbucks
EXPERIENCE
nog839: nog839: visit rating
Count 50 50
Mean 3.92 2.66
Sample Standard Deviation 1.8388106183 1.4513892008
Sample Variance 3.3812244898 2.1065306122
Minimum 1 1
Maximum 7 5
Range 6 4
Confidence interval 95.% lower 0.5096829336
Confidence interval 95.% upper 0.9372103903
half-width
t(df=99)
1st quartile 2 1
median 4 3
3rd quartile 5 4
interquartile range
mode 2 1
low extremes
low outliers
high outliers
high extremes
normal curve GOF
p-value
chi-square(df=5)
E
0

Scatter Plot

Scatterplot Experience vs Frequency

EXPERIENCE 7 5 3 4 4 2 3 5 4 5 6 2 2 3 2 7 6 7 5 3 5 4 3 2 2 2 6 7 3 2 2 4 3 1 3 5 7 6 2 3 4 1 2 6 7 5 6 3 1 4 5 3 2 4 5 1 1 1 2 3 4 2 2 3 1 1 1 1 3 3 2 1 1 1 3 1 4 2 3 4 4 4 3 3 2 1 1 1 4 5 5 5 5 4 3 2 1 1 5 4

Frequency

Experience

Bar Graph

Income

Frequency 15 25 10 50 Percentage 15 25 10 50

Histogram

Frequency and Experience
FREQUENCY 7 5 3 4 4 2 3 5 4 5 6 2 2 3 2 7 6 7 5 3 5 4 3 2 2 2 6 7 3 2 2 4 3 1 3 5 7 6 2 3 4 1 2 6 7 5 6 3 1 4 EXPERIENCE 5 3 2 4 5 1 1 1 2 3 4 2 2 3 1 1 1 1 3 3 2 1 1 1 3 1 4 2 3 4 4 4 3 3 2 1 1 1 4 5 5 5 5 4 3 2 1 1 5 4