Data Analysis and Graphing Techniques

Chester Tuckwell from Blue Peak Computer Training demonstrates how to plot scatter graphs using ice cream sales data from July 2018 and July 2019. The video covers creating an empty scatter graph in Excel, adding data series for both years, and finalizing the graph with trendlines and titles. The tutorial aims to compare sales against temperature to identify trends.

What is the main focus of the video tutorial?

• Analyzing line graphs

• Designing pie charts

• Plotting scatter graphs

• Creating bar charts

Which two years' ice cream sales data are being compared in the video?

• 2017 and 2018

• 2020 and 2021

• 2018 and 2019

• 2019 and 2020

What is the first step in creating a scatter graph?

• Select data

• Create a chart title

• Add a trendline

• Go to the insert tab

Which tab is used to create an empty scatter graph?

• Home

• View

• Insert

• Data

What is the X-axis value for the July 2018 series?

• Temperature

• Sales

• Location

• Time

How do you select the sales amounts for 2018?

• Control + C

• Alt + Tab

• Control + Shift + Down Arrow

• Using the mouse

What trend is observed in the July 2018 data?

• Sales remain constant

• Sales decrease as temperature increases

• Sales increase as temperature increases

• No trend is observed

What is the Y-axis value for the July 2018 series?

• Sales

• Temperature

• Time

• Location

What is the X-axis value for the July 2019 series?

• Location

• Sales

• Temperature

• Time

How do you select the temperature values for 2019?

• Using the mouse

• Control + C

• Control + Shift + Down Arrow

• Alt + Tab