Can someone fix this excel sheet for me? (Chemistry vapor pressure formulas) It\
ID: 477189 • Letter: C
Question
Can someone fix this excel sheet for me? (Chemistry vapor pressure formulas)
It's something our teacher makes us do for our chemistry lab, and we have to type the formulas into excel. For some reason it never seems to work. Can someone just tell me what to type into the cells to get the right calculations?
Mass of Liquid Driven out (g) 0 2 Volume of Liquid Driven Out (mL) 2 Volume of Bubble (mL) Meniscus Reading (mL) Barometric Pressure in the Lab (mmHg) 700 Temperature in the Lab (degC) 22 Vapor Pressure at Room Temperature 741 Partial Pressure of Air in Bubble Vapor Pressure of Liquid -41 Vapor Pressure at Higher Temperatures Trial 2 Trial 3 Trial 1 Trial 4 Temperature (deg C 50 56 62 68 Meniscus Reading (mL) 0.195 0.237 0.296 0.343 0.222 0.272 0.372 Volume of Buble (mL) 0.322 Partial Pressure of Air (mm Hg) Vapor Pressure of Liquid (mm Hg) Table ofData for Graphs an (Pvap) Temp Temp Pvap (degC) (Kelvin) Room Temperature 22 Temperature 1 Temperature 2 56 Temperature 3 62 Temperature 4 68Explanation / Answer
Please check following error in your excel file :
1) for writing formula in cell it should start with = sign. Check cell is starting with = sign or not..
2) if you are getting error symbol for your cell ,then please right click on error symbol and choose 'show calculation'. It will show the error in calculation & try to solve this error.
3) please check space in digit. For eg. Excel reads ' 111' & '111' in different sense while calculation.
4 ) while copy & pasting , be sure about source format. So it's better to not to copy paste.
5) check parentheses in formulas.
Hope this will help you.
If above suggestions doesn't work then please elaborate the actual error with screenshot.