LastName_Excel

.docx

School

Minnesota State University, Moorhead *

*We aren’t endorsed by this school

Course

150L

Subject

Chemistry

Date

Jan 9, 2024

Type

docx

Pages

2

Uploaded by MasterMousePerson897

Report
Using Microsoft Excel Name: Hand-In, Chem 150L, Fall 2022 Partner: Due Monday, Sept. 12, 11:59 pm 1. (2 points) Briefly describe your experimental design and state your original, testable hypothesis of what would happen in the experiment. Design: {Type answer here.} Hypothesis: {Type answer here.} 2. (2 points) Paste your properly formatted Excel data table below. Be sure that the statistics rows are included at the bottom and all values are rounded appropriately. 3. (4 points) Paste your properly formatted Excel graph below. The graph should be at least one-third to one-half of the page in size so that it is easily readable. 4. (4 points) (a) Is there a trend in your data? If so, what kind of trend is it? {Type answer here.} (b) What does the equation of the line tell you, and what is the physical interpretation of the slope? What does the R 2 value tell you? {Type answer here.} (c) Do your experimental results support or refute your original hypothesis? Explain by using data from both your table and graph. {Type answer here.} See the rubric below for more detailed information about grading.
Unsatisfactory Borderline Satisfactory Excellent Pts. Q#1 Hypothesis No hypothesis. 0 points Hypothesis is there but not well stated. 1 point Reasonable hypothesis, but no experiment description. 1.5 points Reasonably stated hypothesis and experimental design. 2 points 2 pts Q#2 Data Sheet No data sheet. 0 points No statistics. 1 point -0.5 pt for each poorly formatted item. 1.5 points Meaningful column labels and widths. Table is easy to follow. Statistics included. Rounding appropriate. 2 points 2 pts Q#3 Graph If the graph is not an x-y scatter plot, the graph earns zero points. 0 points Graph is an x-y scatter plot but does not meet any of the criteria noted in the last column. 1 point -0.5 pt for each minor error. 3 points Graph is large enough to be easily readable and is scaled properly, 1 pt. Correct axis labels and graph title, 1 pt. Best fit line and equation with R 2 value, 1 pt. 4 points 4 pts Q#4 Conclusion No conclusion or answers to questions. 0 points Poorly supported conclusion and one or more parts of question not answered correctly. 1-2 points One part of question not answered correctly or poorly supported conclusion. 3 points Trend described, 1 pt. Equation, slope, and R 2 explained, 1 pt. Conclusion is supported by data presented in table and graph, 2 pts. 4 points 4pts Total 12 pts
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help