Description
I will upload the paper with the data to be put onto excel and analyzed , this is what I need done.
Analyze the data with Microsoft® Excel® or other statistical tool(s), including:
- Descriptive stats for each numeric variable
- Histogram for each numeric variable
Explanation & Answer
I will not take all but go through all the sheets I think there is enough data to write about writing will not take a lot of time but please confirmlook at the stats in the 2nd sheet , this is all what is neede
Statement
Strongly Agree
Agree
Neutral
I am satisfied with my job.
8
6
4
I feel that I am successful at my job.
12
15
4
I feel that I contribute to the organization.
17
12
5
I am motivated to meet sales quotas.
7
4
3
6
8
3
24
16
1
26
14
1
1
2
1
I feel that meeting sales quotas is
reasonable.
A monetary incentive would have an
increase on total sales.
An incentive will have a positive effect on
my working environment.
An incentive will have no effect on my
total sales.
Mean
Mode
Stadnadard Deviation
Min
Max
Range
12,63
#N/A
8,94
1,00
26,00
25,00
For all
Mean
Mode
Stadnadard Deviation
8,80
1,00
8,80
Interquartile range
1,00
26,00
25,00
Min
Max
Range
#VALUE!
9,63
#N/A
5,34
2,00
16,00
14,00
2,75
1,00
1,58
1,00
5,00
4,00
Disagree
Strongly
Disagree
12
14
7
6
4
6
17
13
17
10
2
1
2
1
17
23
9,75
17,00
6,80
2,00
17,00
15,00
9,25
6,00
7,40
1,00
23,00
22,00
44
44
44
44
44
44
44
44
XLSTAT 2016.06.37824 - Descriptive statistics - Start time: 21/11/2016 at 21:36:43 / End time: 21/11/2016 at 21:36:46
Quantitative data: Workbook = Book2 / Sheet = Sheet1 / Range = Sheet1!$B$1:$F$9 / 8 rows and 5 columns
Run again:
Descriptive statistics (Quantitative data):
Statistic
Nbr. of observations
Minimum
Maximum
1st Quartile
Median
3rd Quartile
Mean
Variance (n-1)
Standard deviation (n-1)
Strongly Agree Agree
8
8
1,000
2,000
26,000
16,000
6,750
5,500
10,000
10,000
18,750
14,250
12,625
9,625
79,982
28,554
8,943
5,344
Neutral
8
1,000
5,000
1,000
3,000
4,000
2,750
2,500
1,581
Disagree
Strongly Disagree
8
8
2,000
1,000
17,000
23,000
3,500
4,750
9,500
8,000
17,000
13,250
9,750
9,250
46,214
54,786
6,798
7,402
Box plots:
Box plot (Strongly Agree)
30
18
16
25
14
15
10
12
Agree
Strongly Agree
20
10
8
6
4
5
2
0
0
End time: 21/11/2016 at 21:36:46 / Microsoft Excel 14.07176
8 rows and 5 columns
Box plot (Agree)
Box plot (Neutral)
6
5
Neutral
4
3
2
1
0
plot (Neutral)
Box plot (Disagree)
18
16
14
Disagree
12
10
8
6
4
2
0
Box plot (Strongly Disagree)
25
Strongly Disagree
20
15
10
5
0
XLSTAT 2016.06.37824 - Distribution fitting - Start time: 21/11/2016 at 20:55:25 / End time: 21/11/2016 at 20:55:36 /
Data: Workbook = Book2 / Sheet = Sheet1 / Range = Sheet1!$B$1:$F$9 / 8 rows and 5 columns
Significance level (%): 5
Distribution: Norma...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
You Are a Badass
by Jen Sincero
Daisy Miller
by Henry James
The Subtle Art of Not Giving a F*ck
by Mark Manson
Shutter Island
by Dennis Lehane
The Fault in Our Stars
by John Green
The Prince
by Niccolò Machiavelli
The Lord of the Flies
by William Golding
Dracula
by Bram Stoker
Heart of Darkness
by Joseph Conrad