Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. 3. Where were the measurement units placed in the spreadsheet? a) In each cell next to the measurement value b} In the cell at

image text in transcribedimage text in transcribed
2. 3. Where were the measurement units placed in the spreadsheet? a) In each cell next to the measurement value b} In the cell at the top of each column with column title c) In the cell at the bottom of each column d) No measurement units were specified In the video, how do they enter new data into a cell in their Excel spreadsheet? a) Left-click on a new cell and start typing. b) Right click on a new cell and start typing. c) Left and right click simultaneously on a new cell and start typing. cl) Excel 2013 doesn't allow you to enter data into a new cell. To select data for graphing, the video shows you can a) Left-click on the top left data cell and hold the left mouse button as you drag the mouse over all the data you want to plot. b) Right-click on the top left data cell and hold the right mouse button as you drag the mouse over all the data you want to plot. c) Type \"graph this" at the top of each column you want Excel to plot. d) Type "don't graph this\" at the end of each row you don't want Excel to plot. Once data is selected, you can start creating an X-Y scatter plot by: a) Selecting Insert, then selecting the chart symbol \"' b) Selecting Insert, then selecting the chart symbol a ' c) Selecting Insert, then selecting the chart symbol '5' ' cl) Selecting Insert, then selecting the chart symbol L ' 9. In the video, which column of data was plotted on the horizontal/X axis? a) Left of selected columns b) Right of selected columns Once you have made a chart, how can you quickly add axis titles? a) You can't add anything the chart is what it is. b) Click on the Quick Layout button and select a layout containing axis titles. c) Click on the Quick Layout button and select a layout without axis titles. If you are graphing only one data series on a chart, you don't need: a) A chart title, b) A label for the horizontal axis of the variable's name and its unit of measurement. c) A series legend. d) A label for the vertical axis of the variable's name and its unit of measurement. If you want to add a trendline to the data, how did the video show you to start? a) Right-click on a plotted data point then select Add Data labels in the pop-up menu. b) Right-click on a plotted data point then select Add Trendline in pop-up menu. c) Rightclick on a plotted data point then select Format Data Series. d) Either (a), lb) or (c). All of them will work. If you think your data looks like a straight line, which type of trendline would you fit to it? a) Linear b) Logarithmic c) Polynomial of degree 3 d) Moving Average 10. What information do you think it is good practice to always display about your fitted trendline? a) Its equation b) Its R2 goodness-of-fit value c) Both its equation and its R2 value d) Neither its equation or its R2 value

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Neutrino Physics

Authors: Kai Zuber

3rd Edition

1351764578, 9781351764575

More Books

Students also viewed these Physics questions