Answered step by step
Verified Expert Solution
Question
1 Approved Answer
On the Linear worksheet, take the following steps to complete this DQ: Enter your name in cell I2. This will generate a specific problem for
On the Linear worksheet, take the following steps to complete this DQ: Enter your name in cell I2. This will generate a specific problem for you in the box starting in cell B12. Transfer the coordinates (x0, y0), and (x1, y1) given in B12 to cells (B17, C17) and (B20, C20). Enter a formula for the slope of the line through your two points in cell C23. Recall that the symbolic formula for the slope is m=(y1-y0)/(x1-x0), so your Excel formula will look like =(??-??)/(??-??), where the ?? placeholders are appropriate cell references. Here, you must use cell references for your slope formula, rather than numeric inputs. Enter a formula for the y-intercept of the line through your two points in cell C24. Once you have the slope m, you can use the symbolic formula b=y0-m*x0 (as noted in the box starting in cell B26) for the y-intercept, so your Excel formula will look like =??-??*??, where the ?? are appropriate cell references. Enter x-values in cells E15:E35, starting at x=-5 and progressing by step size 0.5 up to x=5. There are a number of ways to accomplish this; see the video for examples. Enter y-value formulas in cells F15:F35
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started