SSS2 Math Quiz 8.2 – Simultaneous linear and quadratic equations

Create a table in Microsoft Excel with two columns: one for x-values and one for y-values. Input x-values from -5 to 5, and use the linear function y = 2x – 3 to calculate corresponding y-values. Plot the points on a scatter plot in Excel and use the “Insert Trendline” feature to add a linear trendline. What is the equation of the trendline, and how does it compare to the original linear function?

Use Microsoft Excel to plot the graph of the linear function y = -0.5x + 4. Set up a table with x-values ranging from 0 to 10. Plot the points and adjust the formatting to create a visually appealing graph. Then, use Excel’s features to add gridlines, axis labels, and a title to the graph. Analyze the graph to determine the slope and y-intercept of the linear function.

Create a comparative graph in Microsoft Excel to visualize the relationship between two linear functions. Choose two linear functions, such as y = 3x + 2 and y = -2x + 5. Use Excel to generate tables of x-values and corresponding y-values for both functions. Plot the points for each function on the same graph and differentiate them using different colors or symbols. Add a legend to the graph to label each function. Analyze the graph to compare the slopes and y-intercepts of the two linear functions.