Plot the linear relationship between the categorical independent variable (luxon absent or luxon present) and the production of octaphorin by a nerve cell (pg ml^-1). Your plot should follow the formatting guidelines listed below.

Directions: For questions 5-11, download the Excel file, "Data: Production of Octaphorin by Nerve Cells," containing the production of octaphorin by nerve cells (pg ml^-1) in the absence or presence of a luxon (sample size = 30 values per treatment). Use Excel for calculations, modeling, and graphing. Round all calculated values to the nearest tenth of a decimal place. For example, if you calculate the value as 3.8218, round to 3.8.

Formatting Instructions

General

• Chart type: Line
• Quick layout: Layout 1
• Y-axes title: "Production of octaphorin (pg ml^-1)"; Font size = 18
• Y-axis numbers: Font size = 14
• X-axis title: "Treatment"; Font size 18
• X-axis numbers: Font size = 14
• Line: No line
• Note
  • Make sure to resize your figure as needed.
  • Make sure that your categories are labeled "Luxon absent" and "Luxon present" instead of "0" and "1"

Marker

• Marker options: Built in, Filled in circle, Size = 14
• Fill: Solid fill, Color = Black
• Border: Solid line, Color = Black

Error bars Standard deviation

• Direction: Plus
• End style: Cap
• Error amount: Custom Select the appropriate cell in Excel.
• Line: Solid line
• Color: Black
• Width: 2 pt

Y-axis

• Bounds: minimum at 0, maximum at 12
• Tick marks: Major = 1, Minor = 0.5

Identification # of nerve cell	Treatment	Production of octaphorin (pg/ml)
51	luxon absent	0.6
26	luxon absent	0.7
15	luxon absent	0.4
21	luxon absent	0.4
52	luxon absent	0.2
19	luxon absent	0.9
7	luxon absent	0.1
37	luxon absent	0.4
46	luxon absent	0.9
42	luxon absent	0.3
22	luxon absent	0.3
53	luxon absent	0.3
6	luxon absent	0.3
45	luxon absent	0.4
48	luxon absent	0.3
35	luxon absent	0.4
33	luxon absent	0.7
38	luxon absent	0.6
50	luxon absent	0.5
14	luxon absent	0.4
17	luxon absent	0.7
39	luxon absent	0.0
4	luxon absent	0.8
34	luxon absent	0.0
43	luxon absent	0.6
44	luxon absent	0.1
18	luxon absent	0.5
36	luxon absent	0.8
1	luxon absent	0.2
11	luxon absent	0.7
9	luxon present	10.5
8	luxon present	10.0
5	luxon present	10.9
30	luxon present	12.0
27	luxon present	8.9
32	luxon present	5.2
24	luxon present	7.3
55	luxon present	4.7
3	luxon present	8.1
60	luxon present	9.8
49	luxon present	7.2
59	luxon present	11.4
47	luxon present	10.7
16	luxon present	7.1
28	luxon present	7.6
2	luxon present	7.9
56	luxon present	9.9
41	luxon present	10.2
13	luxon present	11.0
29	luxon present	7.2
20	luxon present	13.9
54	luxon present	8.5
31	luxon present	11.0
25	luxon present	8.8
58	luxon present	10.0
12	luxon present	7.4
10	luxon present	7.6
57	luxon present	7.1
40	luxon present	8.9
23	luxon present	9.4