In an experiment there are dependent and independent variables. The independent variable corresponds to factors you are varying and the dependent variable is the one you are measuring. 1. Your school is putting on a play. To raise money for the event, tickets for the play are being sold at different prices (independent variable). Plot a chart to show how many tickets of each category were sold.

Construct column chart of the data with ticket price as x-axis and number tickets as y axis. (5pts).

Paste your column chart here:

Construct pie chart of the data. Convert # tickets sold into percentages first. Chart must have legend and data labels (% value) for each sector. (5pts)

Ticket category	Number of tickets sold
$15	5
$45	15
$75	25
$120	40
$135	45

Paste your pie chart here:

Paste your reorganized data table here:

2. You collected data on the height of 6 species of plants. Plot a line chart of the following data. Hint: You may need to do some calculations before plotting the graph and you need to use excel to sort by sex and species. Be careful when sorting to highlight all columns not just one. Paste your processed (calculated and rearranged) data (5pts). The paste one graph in the space provided (5pts).

Sex	Species	Height (cm)
F	Species 1	1m
M	Species 1	1m 25cm
F	Species 3	1m 13cm
M	Species 4	1m 31cm
F	Species 5	1m 23cm
M	Species 6	1m 5cm
M	Species 2	1m 25cm
F	Species 4	1m 22cm
F	Species 6	1m 23cm
M	Species 3	1m 30cm
M	Species 5	1m 35cm
F	Species 2	1m 11cm

Paste your chart here:

3. A student collects data in an experiment involving acids and bases. The student is adding a base to an acid and noting the pH. First identify the dependent and independent variables so that you know which is the horizontal and vertical axis on the graph. Then plot a scatter plot then plot a best fit straight line graph with the line going through the 0,0 axis. (5pts)

Plot a graph of the best fit polynomial line graph showing the line equation without going through 0,0 (1pt). Then determine pH value if you added 10.5mL of NaOH. Ans:__________(3pt)

mL of NaOH added	Paste your line chart here: pH reading
0	2
1	3.2
2	4
3	4.5
4	5.3
5	5.9
6	7.4
7	8
8	8.9
9	9.5
10	10.2
11	10.9
12	11.5
13	12.1
14	12.5
15	12.8
16	13.1
17	13.5

Answer questions below from Figure 1 only (not from your graph above):

Is the best fitting line a straight line or a curve? Answer: _____________________ (1pt)

Does your line pass through every data point? Answer: ______________________ (1pt)

Paste your polynomial chart here: