How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9666
Experience:  Worked on Macs and PC's for 20+ years.
53785
Type Your Mac Question Here...
John D is online now
A new question is answered every 9 seconds

I have Excel 2011 for Mac installed. I have a dataset of basketball

This answer was rated:

I have Excel 2011 for Mac installed. I have a dataset of basketball scores that I need to convert into a histogram. There are over 1000 scores that range between 5 and 40. I need to put the data into bin ranges of 0-5, 5-10... 35-40. How do I do this?

Hi,

 

Here is file with ome sample scores and their histogram chart

 

Attachment: 2012-03-25_182017_scores1.xlsx

 

Hope this is ok


If you want me to apply it to a specific set of scores please send my your file by attaching it in your reply and I will be happy to set it up for you

 

Thank you

 

 

 

 

 

Customer: replied 4 years ago.
I'm sorry but this service actually took too long and I was able to work out something alternatively. Now I'm having trouble creating a normal quantile plot to test the normality of this data set.

21.98
32.07
26.26
18.27
24.97
15.71
10.78
24.54
16.38
20.32
22.59
18.42
16.48
31.95
20.69
21.22
22.72
16.24
16.62
19.94
21.20
21.76
22.40
16.27
27.15
18.81
13.56
16.91
18.32
14.58
20.87
16.93
14.75
20.36
15.61
19.65
20.02
18.30
22.20
18.07
22.41
16.03
20.35
22.98
18.09
32.16
16.65
11.76
25.39
17.62
13.88
29.28
16.30
19.75
18.59
12.52
17.29
18.55
22.05
16.99
11.14
19.51
17.04
17.71
18.88
13.97
27.05
23.45
15.10
11.92
19.61
18.16
16.27
13.87
21.66
22.84
22.08
13.31
21.64
19.48
17.78
18.63
20.85
23.24
21.25
16.76
28.99
18.63
25.48
20.29
23.53
29.90
20.26
15.82
17.82
17.42
14.71
22.64
14.25
11.18
21.93
17.03
17.45
16.31
35.42
30.63
18.50
13.13
11.94
31.69
18.50
14.73
13.91
23.49
16.77
21.79
20.38
16.22
32.81
13.74
18.89
17.20
23.78
25.85
23.82
21.42
23.47
15.82
24.20
18.41
20.91
25.81
17.59
17.87
16.01
16.40
18.03
20.20
18.29
19.79
15.60
13.69
14.42
17.81
18.83
24.10
28.45
17.03
23.84
19.52
17.91
22.00
16.01
18.46
22.34
26.85
30.37
27.84
12.33
26.36
13.69
13.27
16.81
18.51
23.83
11.06
16.94
17.62
15.33
15.71
12.95
17.66
6.56
17.27
14.32
17.82
16.29
27.01
23.50
12.74
24.36
24.98
11.09
24.61
19.22
14.75
10.81
9.70
15.14
16.93
18.94
15.52
17.30
21.65
23.38
19.20
29.25
18.54
19.41
14.75
17.24
11.50
16.59
28.01
25.43
22.26
27.55
18.46
15.93
17.66
12.21
12.35
22.23
20.42
19.13
21.53
17.12
26.01
35.04
27.38
18.52
19.90
19.59
19.41
20.93
17.24
16.56
19.26
17.78
27.55
17.16
12.63
15.13
17.95
13.71
14.01
13.10
15.85
23.49
11.61
15.29
17.29
11.54
15.60
19.63
32.87
15.36
11.11
13.05
17.52
18.82
13.55
16.89
17.67
17.86
15.42
31.10
17.36
21.34
16.74
18.38
23.35
25.01
12.67
12.61
16.01
21.67
21.32
16.41
22.75
17.31
17.90
16.87
19.81
16.71
17.87
13.37
16.66
11.68
15.06
24.66
23.15
12.75
27.91
22.40
16.81
20.12
25.28
28.45
20.13
18.32
13.86
19.74
18.46
22.27
25.57
21.18
18.05
27.28
21.85
20.00
19.76
26.18
20.57
12.22
22.10
24.28
25.67
15.50
30.24
22.20
25.17
8.50
23.11
13.38
13.51
28.36
25.11
24.13
28.37
31.51
14.15
17.14
14.55
23.91
20.87
25.46
20.73
17.27
17.06
16.80
24.94
23.27
14.26
13.08
17.01
22.81
19.24
15.01
17.12
24.91
24.06
15.11
17.35
14.89
17.39
15.29
15.67
20.26
14.63
19.85
23.87
13.16
15.66
25.56
23.34
18.54
8.68
12.17
12.92
16.20
16.65
24.09
18.33
15.24
17.15
17.31
20.61
18.65
13.91
13.38
19.81
19.73
17.22
13.53
15.70
18.41
17.68
16.95
15.21
17.60
19.52
22.79
21.94
16.32
19.92
19.32
22.04
18.93
18.71
13.44
15.76
17.02
21.59
27.56
17.50
29.19
29.03
12.81
13.99
11.72
25.83
25.05
10.85
29.46
15.10
15.37
23.73
16.82
25.27
16.30
19.08
18.90
25.22
19.71
32.58
11.16
20.42
11.16
24.90
16.63
16.63
23.12
16.93
23.29
21.04
14.11
17.59
19.12
13.42
17.71
19.13
21.98
21.59
16.44
18.81
24.70
17.91
22.14
14.17
13.99
19.98
32.47
24.32
19.33
20.51
23.25
21.62
13.72
24.03
21.26
21.76
16.34
20.33
17.58
14.68
13.21
22.47
10.34
22.83
17.47
24.74
17.84
12.20
14.37
18.13
17.62
20.87
16.36
22.01
15.16
15.14
18.30
15.78
16.94
23.29
6.90
24.25
19.01
21.30
15.74
15.02
17.72
18.43
20.80
17.03
19.12
23.97
11.48
13.07
33.63
21.19
28.38
14.98
18.95
22.22
14.45
10.21
14.64
23.33
17.10
12.89
18.86
22.40
23.29
24.63
27.89
19.91
19.92
10.47
15.23
28.19
11.60
19.28
25.76
21.19
17.28
18.73
9.95
20.24
17.28
18.66
20.62
17.49
19.78
19.50
25.16
20.65
18.34
17.07
15.34
16.16
16.13
20.24
20.66
15.56
14.83
26.23
20.97
21.39
20.19
17.75
23.57
18.61
19.43
13.32
11.94
15.31
16.66
22.89
11.72
23.20
32.30
17.60
18.47
33.82
30.74
9.46
16.41
17.50
22.06
10.45
12.21
29.34
23.36
17.31
18.48
23.60
15.33
18.67
10.13
19.07
22.04
18.60
13.36
15.10
15.99
20.37
21.63
17.04
20.33
17.45
19.50
22.41
14.72
16.78
22.15
19.48
19.66
22.31
18.87
18.42
15.93
15.56
19.89
18.83
12.82
19.64
21.55
15.28
11.56
13.72
21.76
13.34
11.73
19.28
18.14
20.55
10.97
16.34
23.18
17.45
24.95
22.92
24.15
20.59
21.01
28.35
22.35
32.05
11.41
20.10
15.31
17.12
16.03
20.63
25.45
15.75
11.89
14.47
14.37
25.97
20.36
14.27
18.24
14.50
17.21
22.10
14.95
25.83
13.64
11.96
19.11
22.09
17.42
13.83
25.52
25.23
18.96
23.29
19.87
13.80
14.78
15.60
17.50
23.39
21.89
29.99
37.46
31.19
14.80
19.37
15.33
13.42
23.07
19.97
21.03
25.75
25.19
25.30
19.97
19.19
22.27
22.44
18.84
21.85
16.77
16.16
18.74
16.18
20.18
20.31
27.46
28.72
20.92
10.99
17.80
17.43
21.45
21.32
17.78
16.64
10.99
18.21
16.15
30.51
18.89
19.08
12.58
17.31
16.19
17.31
22.24
17.95
23.94
14.05
13.82
17.08
26.24
18.30
9.99
18.30
16.95
18.41
21.30
20.74
21.78
26.04
18.90
23.18
18.74
11.52
27.79
15.48
11.66
17.43
19.04
18.32
16.15
25.66
20.16
12.39
17.01
21.48
29.70
29.15
22.70
18.50
10.16
17.23
21.65
19.13
25.09
10.55
16.42
21.87
25.79
14.39
16.15
18.00
21.18
16.67
19.58
16.03
17.08
19.51
15.39
16.73
21.63
24.10
16.81
16.30
23.24
12.58
16.03
18 .69
20.32
15.54
21.40
20.93
21.34
20.02
23.94
16.93
20.12
11.36
17.68
17.96
24.34
15.07
13.58
16.64
23.81
15.40
22.71
11.31
13.21
16.29
27.26
17.49
31.64
22.93
21.68
31.43
17.34
21.26
10.33
26.22
17.45
11.39
15.21
31.75
27.36
22.72
17.41
16.75
30.40
17.38
17.75
14.64
19.79
16.52
12.13
12.09
15.54
15.23
14.81
10.70
21.75
22.33
25.16
13.27
24.15
23.09
19.58
19.80
15.91
14.77
21.69
18.88
18.71
13.09
14.63
15.89
25.41
18.28
17.99
20.13
16.15
26.10
19.63
22.25
11.91
18.91
16.21
13.20
14.17
22.09
20.31
11.86
16.58
18.34
15.34
13.23
20.96
16.73
23.22
17.76
15.53
22.13
13.68
19.72
18.64
21.07
24.67
14.99
16.96
22.00
22.76
21.84
27.85
21.87
28.90
19.73
12.27
15.36
7.82
22.41
14.54
18.26
16.94
18.21
23.21
16.52
14.52
11.88
17.16
14.05
14.73
13.35
18.93
23.85
15.47
18.68
23.01
31.66
31.49
17.25
31.86
13.47
24.11
16.94
21.37
15.78
9.34
20.96
18.00
15.32
20.54
21.12
21.76
18.35
22.50
25.70
18.54
13.42
23.96
22.94
15.49
31.89
20.56
25.74
13.78
20.21
17.71
25.86
24.64
23.33
11.19
17.71
16.47
16.32
20.18
13.64
15.90
18.70
20.41
14.79
20.74
17.17
19.98
24.42
28.27
9.81
18.37
11.59
10.30
20.48
23.80
18.95
20.93
21.86
25.14
21.40
13.34
25.57
28.14
24.47
21.20
16.93
26.29
17.61
20.58
20.31
25.89
26.34
23.35
10.71
16.73
21.44
21.20
20.37
11.95
6.22
12.49
16.19
18.69
15.39
15.99
18.18
20.72
22.46
15.41
16.81
24.07
16.70
16.32
13.74
27.70
18.34
15.58
21.27
14.22
22.53
15.70
30.46
24.36
20.44
19.07
18.93
17.14
21.18
19.26
37.79
14.44
21.50
19.34
20.79
16.23
16.94
19.16
18.63
21.40
14.43
23.24
20.58
16.80
27.73
18.56
23.57
25.15
16.08
19.73
17.64
16.47
26.40
23.59
17.24
21.56
16.10
20.19
17.72
11.09
18.26
13.12
18.29
15.96
20.62
24.19
32.07
16.16
15.10
14.85
18.78
19.35
16.49
18.27
18.47
19.22
8.18
20.32
15.22
20.81
30.06
27.53
14.37
18.07
19.79
23.83
13.41
24.82
17.93
10.30
17.47
19.03
10.22
14.42
21.99
18.59
18.24
20.10
18.07
18.93
14.18
21.20
18.25
25.21
18.31
15.52
16.52
18.80
21.15
20.72
18.78
18.41
19.49
27.78
20.68
14.56
20.67
16.21
17.23
13.87
11.32
17.89
15.04
28.78
21.32
14.92
22.56
18.73
23.04
19.52
19.79
21.77
15.84
19.75
16.17
20.23
13.84
16.96
20.74
18.39
16.45
19.94
22.45
21.09
15.58
17.35
13.76
17.58
21.03
16.66
16.52
23.28
19.36
14.69
23.45
25.84
20.41
21.17
19.79
18.33
15.94
17.26
13.83
13.09
22.99
26.18
14.42
15.91
20.06
25.06
17.83
13.57
16.02
25.67
16.35
23.06
16.76
16.48
16.06
24.91
26.55
30.06
21.56
7.88
17.92
20.99
18.69
23.89
22.70
18.05
11.24
13.88
13.02
19.12
17.97
17.50
19.20
25.08
16.12
17.72
8.92
26.53
16.97
19.10
14.45
17.36
27.89
32.32
13.99
29.19
23.83
24.52
16.96
16.38
22.76
14.91
31.48
24.71
27.37
24.48
23.23
16.28
20.53
17.66
18.46
17.09
21.32
25.75
18.09
10.70
24.56
11.74
15.15
19.34
18.48
16.56
18.85
20.06
17.54
21.13
21.55
11.82
24.21
14.26
22.06
23.50
20.62
31.83
14.87
23.43
15.92
13.32
14.14
18.41
18.85
14.56
19.07
18.62
15.06
17.39
33.20
17.49
25.92
13.79
19.58
15.51
22.35
19.43
22.99
25.72
30.88
27.45
31.72
26.94
21.03
30.58
12.25
27.63
21.23
8.68
16.26
12.12
18.31
22.97
18.09
14.71
19.97
20.15
14.26
18.41
14.29
20.73
11.10
23.12
19.22
17.38
12.00
15.10
23.87
19.95
20.16
16.55
21.19
19.50
18.54
14.32
16.73
23.34
17.58
21.08
17.63
20.26
20.23
15.15
17.89
17.83
18.41
24.86
15.41
14.95
19.89
19.26
18.96
25.31
21.19
21.44
15.35
25.48
17.66
18.47
20.97
23.07
28.07
14.99
13.29
17.75
14.12
29.37
18.63
21.30
20.81
13.45
24.48
18.16
13.30
13.62
24.74
23.10
28.27
11.72
14.63
22.79
14.87
17.48
17.04
16.00
15.96
23.13
20.61
19.85
18.88
20.95
12.02
11.71
15.56
15.05
19.77
14.55
25.03
26.45
16.18
26.73
25.43
20.68
21.54
28.15
12.37
19.33
21.52
20.03
23.57
18.01
21.26
18.20
15.32
14.34
19.19
21.64
13.49
24.53
19.45
22.21
21.19
20.57
26.25
26.32
20.28
15.41
21.12
10.25
24.12
20.90
20.50
17.52
14.33
23.06
28.59
19.32
21.76
6.65
12.11
24.43
20.84
21.51
19.86
20.34
15.11
21.25
15.28
17.07
22.68
16.84
23.54
22.03
15.21
14.28
20.98
22.56
29.51
14.80
14.77
11.66
14.01
17.43
20.06
24.73
19.96
18.28
22.30
29.25
18.57
18.07
13.33
20.91
15.80
11.75
15.12
18.02
11.97
24.42
33.49
16.09
19.93
11.42
13.29
11.50
20.82
14.87
19.15
23.48
21.97
17.71
20.61
21.12
16.01
12.80
26.32
20.15
20.18
20.28
24.50
18.13
19.66
23.19
16.77
14.94
16.40
13.23
12.13
20.92
13.35
23.77
21.67
21.96
19.13
16.51
25.17
17.28
15.47
20.89
22.22
15.07
18.81
17.32
14.23
14.52
12.35
20.10
16.09
17.42
21.25
16.70
22.98
18.97
17.13
16.63
21.03
19.10
27.83
27.92
15.06
32.66
20.71
24.91
16.44
18.42
16.06
19.44
22.33
29.58
29.34
16.87
19.63
16.44
18.61
22.14
15.46
17.04
17.71
12.74
15.94
13.08
8.36
14.92
18.41
23.71
19.21
21.16
24.03
20.49
15.82
16.52
25.10
22.23
13.81
18.41
19.07
18.71
17.00
19.06
24.46
17.86
17.75
18.17
14.51
13.80
9.52
21.14
14.87
16.60
18.64
24.52
18.19
13.56
26.23
26.49
22.29
20.42
21.54
16.01
13.96
14.01
19.57
17.04
18.68
16.23
29.07
22.66
15.97
15.82
20.33
25.34
19.67
17.82
15.60
12.99
17.74
19.97
17.38
16.07
23.12
14.14
13.92
14.78
25.16
16.59
25.15
21.31
17.53
19.73
28.67
16.69
25.29
16.39
14.93
22.90
15.25
19.13
14.30
19.10
19.72
21.17
20.58
19.46
18.45
13.86
20.94
29.21
17.73
20.90
19.57
20.25
14.46
23.27
15.34
26.94
22.10
29.12
17.40
29.65
26.96
19.94
15.97
22.37
16.49
20.04
20.54
22.89
19.39
24.17
20.13
20.67
18.89
17.44
11.12
13.74
18.65
20.78
13.55
14.17
15.72
12.48
16.02
15.25
16.55
22.72
18.10
17.31
10.89
20.05
23.17
18.05
20.09
17.97
23.67
13.30
16.62
24.00
5.74
25.95
20.39
24.95
28.35
18.11
17.12
16.15
26.75
25.61
20.57
12.60
23.75
15.19
15.24
24.86
20.00
18.98
14.12
9.23
14.48
18.50
18.33
11.42
21.53
19.18
14.45
15.61
20.17
22.52
20.10
13.66
24.03
36.72
24.94
21.60
29.27
22.91
17.11
20.27
19.02
20.29
23.66
15.02
22.41
16.83
21.62
19.70
14.79
16.91
28.78
18.16
16.49
14.50
20.85
14.89
11.67
28.56
20.71
20.45
15.61
23.74
20.99
22.46
28.13
24.46
16.16
18.41
16.37
20.78
21.91
12.81
30.54
22.09
18.17
12.31
19.02
20.28
20.14
12.74
11.32
14.62
19.81
19.71
22.22
17.65
23.31
23.69
17.68
13.83
20.78
25.56
19.84
19.39
20.25
11.83
16.03
14.84
14.78
20.21
12.48
19.83
24.50
20.30
12.39
18.67
11.50
25.25
24.57
24.85
24.82
17.47
16.00
22.34
16.45
14.28
26.74
14.07
12.01
21.98
18.11
22.76
20.09
18.59
19.02
27.15
17.64
21.58
22.73
17.67
21.69
16.09
16.78
13.09
18.40
25.72
22.74
19.03
26.61
18.83
20.55
22.23
21.01
19.30
22.10
17.57
16.27
14.40
16.07
21.78
17.14
17.77
9.05
20.29
17.38
19.81
25.32
21.09
24.37
29.77
19.40
22.62
14.91
17.81
18.01
20.64
17.35
19.34
15.92
21.17
17.40
17.57
18.73
19.13
20.13
13.70
23.01
20.43
22.47
16.41
22.68
27.52
23.02
20.55
19.01
14.25
21.22
19.82
9.33
26.41
15.82
17.13
12.69
12.68
11.70
22.01
22.40
15.82
9.87
26.38
16.66
16.23
25.44
19.35
11.93
16.52
17.09
15.32
21.26
18.34
24.97
17.63
18.39
21.28
33.40
33.16
29.22
18.88
17.64
22.15
21.24
22.08
22.29
11.96
23.19
21.21
19.95
19.32
16.24
18.13
16.55
25.90
15.97
17.15
24.98
28.39
13.92
17.74
17.95
14.08
17.66
23.45
20.26
16.04
21.24
19.98
27.81
14.35
10.93
14.67
12.51
25.11
21.98
15.02
19.10
16.74
21.02
14.59
18.88
12.78
15.78
21.45
18.49
17.55
29.08
19.58
18.99
14.41
19.34
14.23
20.52
21.55
18.01
22.78
23.82
14.60
12.27
31.28
20.97
24.35
16.08
13.38
25.04
19.89
18.47
14.16
13.20
19.73
31.04
14.91
22.25
26.93
19.81
19.94
13.77
11.81
11.08
12.27
16.08
30.47
21.01
11.42
23.83
27.04
16.49
13.40
15.80
23.72
16.59
14.98
18.73
24.84
9.88
21.17
22.66
21.50
16.14
22.51
12.85
14.21
23.06
13.45
12.70
25.25
18.22
23.10
13.06
21.06
17.66
13.66
22.55
18.77
19.70
14.94
17.30
17.48
21.07
16.32
20.64
15.93
12.42
16.26
18.14
20.26
26.74
19.10
15.32
17.21
22.06
16.64
22.66
14.69
15.88
16.27
18.77
23.30
23.14
17.02
18.67
33.06
14.86
29.35
12.37
14.52
15.85
17.95
23.08
18.58
21.18
22.03
15.55
17.85
18.50
21.20
23.85
22.96
20.56
9.57
25.87
13.46
18.22
17.49
25.77
17.15
22.41
17.32
33.59
19.44
21.61
17.15
12.63
16.48
15.84
14.80
25.73
22.07
18.97
25.25
19.62
12.61
23.42
21.38
13.54
16.94
17.21
25.76
34.43
26.38
20.13
17.84
17.00
17.49
17.48
14.55
19.31
30.44
24.15
21.59
20.65
20.51
6.56
22.02
20.91
18.76
18.69
20.92
18.16
24.89
26.41
22.51
20.06
18.80
17.26
14.60
15.39
16.97
19.48
14.67
24.13
21.38
16.26
8.66
18.93
25.38
18.44
12.53
17.63
19.47
19.24
15.11
17.72
17.45
25.37
25.68
20.96
16.26
16.70
15.05
12.38
23.67
13.85
18.45
10.98
26.33
16.09
15.63
27.20
13.11
15.69
28.25
26.11
12.29
15.11
19.83
19.79
16.08
20.91
19.50
14.04
27.59
21.32
13.20
23.27
18.84
16.43
16.37

That is a totally different question. You need to accept the first answer if the solution that I gave you for the first question is correct.

 

Thank you

 

Customer: replied 4 years ago.
If I accept the answer will you be able to answer the second asap? I need it within the next 20 minutes if possible.
I'm really sorry to be a pain but I need this desperately for an assignment and I would love your help.

Is this what the normal quantile plot for your data should look like.

 

graphic

Customer: replied 4 years ago.
Yes I think that's correct! Is it possible to get the central axis on the left?

Yes I think I can do that. Go ahead and accept, then you add bonus if you like (to cover the two questions) when we're done

 

 

John D and 3 other Mac Specialists are ready to help you
Customer: replied 4 years ago.
Thank you, XXXXX XXXXX appreciate this. I'm sorry for being difficult

Thanks!

 

One moment, uploading the file.....

 

 

Ok here you go

 

Attachment: 2012-03-25_200524_quantile.xlsx

 

Hope this is ok. Let me know if you have any questions

 

 

 

Customer: replied 4 years ago.
Thank you that's perfect! I'll definitely use you again if I have any more Excel problems

Great. Will look forward to assisting you again on any Excel issue