How to Plot Constant Temperature and Pressure Lines in Excel for Thermodynamics?

In summary, the student is seeking help with plotting 3 lines of constant temperature and pressure on PV and TV diagrams for air. The professor provided a table for Ideal-gas properties of air, but did not give any data for the plot. The student is not familiar with using the Charting Wizard and is unsure of the relationship between P and V for an ideal gas. However, they confirm that air at 300K can be considered an ideal gas.
  • #1
tsukuba
47
0

Homework Statement


Hello, My thermodynamics professor gave us homework to plot 3 lines of constant temperature on a PV diagram in excel and 3 lines of constant pressure on a TV diagram.
I have no clue how to do this and was wondering if someone could help me

Homework Equations


He gave us the table for Ideal-gas properties of air

The Attempt at a Solution


have not attempted since I am not sure how to do it
 
Physics news on Phys.org
  • #2
tsukuba said:

Homework Statement


Hello, My thermodynamics professor gave us homework to plot 3 lines of constant temperature on a PV diagram in excel and 3 lines of constant pressure on a TV diagram.
I have no clue how to do this and was wondering if someone could help me

Homework Equations


He gave us the table for Ideal-gas properties of air

The Attempt at a Solution


have not attempted since I am not sure how to do it

So you have the Excel data, and just are not familiar with using the Charting Wizard?
 
  • #3
he didnt give us any data. He just said Plot 3 constant temperature lines of your choice, e.g., T=300K on a single P-V diagram for air. In addition plot 3 constant pressure lines of your choice, e.g., P=1atm on a single T-V diagram for air.
 
  • #4
You know what the relationship between P and V is for an ideal gas ? Can air at 300 K be considered an ideal gas ?
 
  • #5
I am not sure what the relationship is but yes air at 300K can be considered an ideal gas
 
  • #6
tsukuba said:
I am not sure what the relationship is

Ideal Gas Law...?
 

FAQ: How to Plot Constant Temperature and Pressure Lines in Excel for Thermodynamics?

What is a PV diagram in Excel?

A PV (Pressure-Volume) diagram in Excel is a graphical representation of the relationship between pressure and volume of a gas. It is commonly used in thermodynamics to analyze and visualize the changes in pressure and volume of a gas during a process.

How do I create a PV diagram in Excel?

To create a PV diagram in Excel, you can use the "XY (Scatter)" chart type. First, enter the pressure and volume data into two columns in an Excel spreadsheet. Then, select the data and insert an XY (Scatter) chart. Finally, customize the chart by adding axis labels, a title, and any other desired formatting.

What is a TV diagram in Excel?

A TV (Temperature-Volume) diagram in Excel is a graphical representation of the relationship between temperature and volume of a gas. It is used to analyze and visualize the changes in temperature and volume of a gas during a process, similar to a PV diagram.

Can I create a combined PV-TV diagram in Excel?

Yes, it is possible to create a combined PV-TV diagram in Excel by using a 3D scatter plot chart. This allows you to plot data points in three dimensions, with pressure on the x-axis, temperature on the y-axis, and volume on the z-axis. This can provide a more comprehensive visualization of the gas's behavior during a process.

How can I use a PV or TV diagram in Excel for data analysis?

PV and TV diagrams in Excel can be used for data analysis by visually identifying patterns and relationships between pressure, temperature, and volume data. They can also be used to calculate important parameters such as work, heat, and efficiency in thermodynamic processes. Additionally, they can be used to compare different processes and determine the most efficient or effective one.

Similar threads

Plotting the waveforms of the harmonic components
Replies
4
Views
2K
How can you modify Python code for effective graph plotting?
Replies
6
Views
489
Temperature after closing the valve
Replies
8
Views
1K
Thermodynamics - temperature, pressure and heat
Replies
11
Views
2K
Volume, pressure and final temperature
Replies
11
Views
2K
Constant pressure specific heats when temperature changes
Replies
13
Views
2K
Modelling Diesel Cycle in Excel.
Replies
4
Views
5K
Thermofluids Air Conditioning Unit TS diagram
Replies
1
Views
1K
Understanding Pressure Changes in Thermodynamics: Explained with an Example
Replies
2
Views
1K
Pressure, Volume, and Temperature at a Point in a Thermodynamic Cycle
Replies
1
Views
1K

Hot Threads

Recent Insights

Back
Top