Question
please do BOTH graph 1 And graph 2 on excel please. data is attached
Evaporation, mm ata Table 1: Measured temperatures for just ethanol and 1-propanol. You will be using the data from here to
Graph 1 1. Using Excel, create a graph using the data from data table 1 comparing the Experimental AT to the molar mass for j
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Table 1
Substance    Experimental DT (C) Molar Mass (g/mol)
ethanol 11.6 46.07
1-propanol 9.5 60.09

Graph 1 : Experimental Delta T vs Molar Mass 14 12 10 y=-0.149x + 18.50 R2 = 1 8 Experimental DeltaT(in C) 6 Graph 1 Linear (

Table 2 for Graph 2
Substance Experimental DT (in C ) Molar Mass (g/mol)
methanol 13.6 32.04
ethanol 11.6 46.07
1-propanol 9.5 60.09
1-butanol 7.2 74.121

Graph 2: Experimental Delta T vs Molar Mass 16 14 12 10 Experimental Deltat (in C) 8 y = -0.151x + 18.53 R2 = 0.999 6 Graph 1

Add a comment
Know the answer?
Add Answer to:
please do BOTH graph 1 And graph 2 on excel please. data is attached Evaporation, mm...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • need help with graph 1 and graph 2 please do on excel Graph 1 1. Using...

    need help with graph 1 and graph 2 please do on excel Graph 1 1. Using Excel, create a graph using the data from data table 1 comparing the Experimental AT to the molar mass for just ethanol and 1-propanol. Add a trendline between the two data points plotted in the excel graph and generate a linear equation for the trendline. 2. Using the equation for the trendline found above, one at a time plug in the molar mass for...

  • Liquid Molar Mass (g/mol) Polarity (P, NP) Strongest type of Intermolecular Force Molecular structure Methanol Po...

    Liquid Molar Mass (g/mol) Polarity (P, NP) Strongest type of Intermolecular Force Molecular structure Methanol Polar hydrogen bonds Ethanol Ipolar 1-Propanol polar 11-Butanol Ipolar n-Hexane Inon- polar n-Heptane Inon- I polar n-octane non- polar Acetone Polar 2- propanol polar 1. Which liquid tested has the strongest intermolecular forces? Justify your answer. (pt) Table 2 (15pes total) Minimum AT Initial Liquid temperature (°C) Methanol 17.8°C Ethanol 20+C |- Propanol 19.5°C 1-Butanol 19.8°C In-Hexane 18.4°C n-Heptane 20.7°C In-octane 19.4°C | Acetone 20.1.0...

  • Instructions for Excel Assignment 2 a) Using the data in the file (i.e., the values of...

    Instructions for Excel Assignment 2 a) Using the data in the file (i.e., the values of Y and values of X), create a scatter plot with the variable Y plotted vertically and the variable X plotted horizontally. You are to add a trendline, the equation of the line and R to this scatter plot. You do not need to add a title to this plot. b) Run the 'Regression' analysis tool (found under DATA/Data Analysis). The output using this tool...

  • Instructions for Excel Assignment 2 a) Using the data in the file (i.e., the values of...

    Instructions for Excel Assignment 2 a) Using the data in the file (i.e., the values of Y and values of X), create a scatter plot with the variable Y plotted vertically and the variable X plotted horizontally. You are to add a trendline, the equation of the line and R to this scatter plot. You do not need to add a title to this plot. b) Run the 'Regression' analysis tool (found under DATA/Data Analysis). The output using this tool...

  • Instructions for Excel Assignment a) Using the data in the file (i.e., the values of Y...

    Instructions for Excel Assignment a) Using the data in the file (i.e., the values of Y and values of X), create a scatter plot with the variable Y plotted vertically and the variable X plotted horizontally. You are to add a trendline, the equation of the line and R2 to this scatter plot. You do not need to add a title to this plot. b) Run the ‘Regression’ analysis tool (found under DATA/Data Analysis). The output using this tool should...

  • 6. Calcium hydroxide, Ca(OH)2, is slightly soluble in water. The concentration of the hydroxide ion present...

    6. Calcium hydroxide, Ca(OH)2, is slightly soluble in water. The concentration of the hydroxide ion present in a saturated solution was determined at various temperatures by titration with a standardized hydrochloric acid solution, and was collected as follows: Temperature / °C 10 20 30 40 50 [OH"]/mol L- 0.02684 0.02465 0.02276 0.02113 0.01970 a. Write the chemical reaction showing the dissociation of Ca(OH)2 in water. Determine the molar solubility of Ca(OH)2 at 10°C, using an ICE table to assist in...

  • 1. Calculate what the pressure of the air is in the flask at each of the...

    1. Calculate what the pressure of the air is in the flask at each of the temperatures for Trials 1 through 5. The temperature is related to the temperature (at constant volume and number of moles) through Gay-Lussac's Law. 2. Calculate the natural logarithm of the vapor pressures, ln(P/P^-), where P^- is 100 kPa. 3. Calculate the inverse of the absolute temperatures. 4. Prepare a graph (either by hand or in excel) with ln(P/P^-) plotted on the y-axis and 1/T...

  • Instructions for Excel a) Using the data in the file (i.e., the values of Y and...

    Instructions for Excel a) Using the data in the file (i.e., the values of Y and values of X), create a scatter plot with the variable Y plotted vertically and the variable X plotted horizontally. You are to add a trendline, the equation of the line and R2 to this scatter plot. You do not need to add a title to this plot. b) Run the ‘Regression’ analysis tool (found under DATA/Data Analysis). The output using this tool should result...

  • Instructions for Excel Assignment 2 a) Using the data in the file (i.e., the values of...

    Instructions for Excel Assignment 2 a) Using the data in the file (i.e., the values of Y and values of X), create a scatter plot with the variable Y plotted vertically and the variable Xplotted horizontally. You are to add a trendline, the equation of the line and R2 to this scatter plot. You do not need to add a title to this plot. b) Run the 'Regression analysis tool (found under DATA/Data Analysis). The output using this tool should...

  • Need to graph in excel, complete numbers 1 and 2. will thumbs up for completing correctly....

    Need to graph in excel, complete numbers 1 and 2. will thumbs up for completing correctly. thank you The decomposition of ozone is important to many atmospheric reactions: 03 (9) 02 (9) + 0 (9) A study of the kinetics of the reaction resulted in the following data: Temperature (K) Rate Constant ( Ms) Temperature (K) Rate Constant (M 1.54) 600 3.37 x 10 1300 7.83 x 10 700 4.85 x 104 1400 1.45 x 100 800 3.58 x 10...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT