mjb08a_E11_RETURNED - . the data range, remove the data...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
1. Create the slope formula on the perfect tab in C3:C12. Leave Cell C2 Empty. 2. Chart the data using Scatter, scatter with smooth lines without markers. 4. Be sure that Cokes is the Value X axis title below the axis and that Pizzas is the Primary Vertical Axis Vertical Tit l e 5. Make the graph title "Pizza to Cokes Relationship" 6. Resize the graph to fit the range D1:K12 3. When selecting the data series, make Cokes the X axis and Pizzas the Y axis data series. Do not graph the slope
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: . the data range, remove the data ranges prior to adding them back as individual series. Cokes Pizzas Slope 2 1 4 2 2 6 2 3 7 1 4 8 1 5 9 1 6 11 2 7 14 3 8 17 3 9 19 2 10 21 2 2 10 20 Pizza to Pizzas 4 6 8 10 12 Cokes Relationship Cokes Key 9370affde322f57ea133b5ee53f561f4a Student ID 000425711 First Name Matthew Last Name Brown Email [email protected] Assignment E11 Assignment Assignment E11 Excel Activity...
View Full Document

This note was uploaded on 05/01/2010 for the course BUS 5529 taught by Professor Wood during the Spring '10 term at Abilene Christian University.

Page1 / 4

mjb08a_E11_RETURNED - . the data range, remove the data...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online