Based on what you have learned from Module 6-9, make a mini-
research which is quantifiable and apply the appropriate measures of
position and percentile rank to interpret the result of your research data.
Follow the format in developing a mini-research.
25 POINTS IF YOUR ANSWER CORRECT THANK YOU!
Answers & Comments
Answer:
Example for using Microsoft Excel
Suppose we have the scores on a 15-point quiz. In Excel, the scores are listed in Column A and the frequency of
each score is shown in Column B.
Column A
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Column B
5
8
3
2
1
5
9
2
0
0
0
12
15
9
4
12
To make a chart: Highlight the output, Column B. Now click on the Insert tab. The third group from the left is
marked Charts. Click on Columns, pick the top left in the 2D column, called Clustered Column. A chart is made,
but it contains the default horizontal values and has no titles.
Add a title: Right click on the graph in the plot area left click select data, highlight Series 1, and click Edit. Type
in “Quiz 1 Grades” for Series Name Title and click OK. This places a title. On the right side, you will see a legend
marked Quiz 1 Grades. Since we only have one set of data, remove this legend. Click on this box and delete.
Add the correct horizontal values: Right click on the graph. On the right side, click Edit Horizontal
(if not there click on Data Source, then in the right box under horizontal, click on Edit). Highlight
column A, click ok. Your horizontal values should be correct.
Add the horizontal and vertical titles: Click on the graph, click on the Layout tab at the top (not
Page Layout tab). In the box marked labels, click on Axis Titles. Pick Horizontal Title option,
choose Horizontal below the data, type “Scores” into the box provided. Go through this part again
but pick Vertical Title option, choose Rotated Title, and type “Number of people” in the box provided.
To make black lines around each bar: Right click a bar in the chart, then select Format Data
Series, pick Border Color and click on Solid Line. The default color is black. Now on border style
you can change the width and types of line.
To change a bar graph into a histogram: You make the bar graph first, follow all the steps above and make sure
you make black lines around your bars. Click on one of the bars, select Format Data Point. Change gap width
from 150%(default) to 0. Click OK
Step-by-step explanation:
Hope it helps #CarryOnLearning