Question: Good figure caption Instructions: This assignment will require you to use Excel to make a series of graphs and answer related questions. Detailed instructions of

Good figure caption

Good figure caption Instructions: This assignment
Instructions: This assignment will require you to use Excel to make a series of graphs and answer related questions. Detailed instructions of how to use Excel for graphing are found in the lab manual, Appendix 4. All graphs and answers to questions must be your own work. You may not work with other students for this assignment. 1. An experimenter measured the volume occupied by a gas at a series of temperatures, gathering the data in the table below. Produce an appropriate graph to determine the relationship (if any) between these two quantities. Temperature (C) Volume (mL) -102 133 115 248 39.0 200 365 371 262 290. 195 285 a. Enter the data into an Excel spreadsheet in the appropriate columns. (Think: Which is the independent variable and which the dependent variable? Over which variable did the experimenter have control? What was measured as a function of what?) Follow the procedure given in Appendix 4, Part B to produce a linear plot of this data set including a trendline and R2 value. Using the "Checklist for a Presentable Graph" in Appendix 4, Part C, format and save the graph. This is Figure 1. The caption should be descriptive of the data and include the trendline equation and R2 value. b. Examine the points on the graph. Determine if they all appear to fit well on the trendline. You might want to examine the R' value as well. Return to the data spreadsheet and delete any questionable point(s). (To do this, click on the number of 11

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!