Descriptive Statistics and Interpretation, math homework help

User Generated

nvesbeprtvey

Mathematics

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

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
Great study resource, helped me a lot.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags