Inserting Phase Change Lines into Microsoft Excel® Graphs

Erick M Dubuque1

  • 1grid.412724.6000000012107308XApplied Behavior Analysis Program, Spalding University, Mansion East, Office #214, 845 South 3rd St., Louisville, KY 40203 USA.

Related Concept Videos

Transformations of Functions II01:29

Transformations of Functions II

Transformations in mathematics alter the position or orientation of a function’s graph while preserving its fundamental shape. One important type of transformation is the horizontal shift, which involves modifying the input variable within a function’s equation. This operation affects where outputs occur along the horizontal axis but does not alter the function’s overall structure.A horizontal shift is achieved by replacing the input variable x with either x + c or x - c,...
228
Microsoft Excel: Plotting Mean, SD, and SE01:18

Microsoft Excel: Plotting Mean, SD, and SE

In Microsoft Excel, plotting the mean along with standard deviation (SD) and standard error (SE) helps visualize data variability and reliability. To plot these values, follow these steps:
First, calculate the mean, SD, and SE of your data. The mean is obtained using the formula `=AVERAGE(range)`, while SD can be calculated with `=STDEV.P(range)` for a population or `=STDEV.S(range)` for a sample. SE is calculated as `=SD/SQRT(n)`, where `n` is the sample size.
To plot these values, use a bar...
1.5K
Transformations of Functions I01:29

Transformations of Functions I

A function's graph can be modified by changing its position or size without altering its overall shape. These transformations allow the graph to be moved across the coordinate plane while preserving its pattern and structure. One of the most common transformations is shifting, which repositions the graph without distorting it.When the output of a function is adjusted by adding or subtracting a constant, the graph shifts vertically. A positive value moves the graph upward, while a negative value...
249
Transformations of Functions III01:20

Transformations of Functions III

Transformations modify the graphical representation of a function without changing its fundamental form. One common transformation is reflection, which flips the graph across a designated axis. When the vertical coordinates of all points are multiplied by the negative one, the entire graph is mirrored over the horizontal axis. This transformation reverses the vertical orientation of peaks and troughs, akin to signal inversion in electrical systems, where a waveform is flipped, but the timing of...
261
Tangent to a Curve01:30

Tangent to a Curve

The graph of a function where each output is the square of the input creates a smooth curve that bends upward, becoming steeper as one moves further from the center. At any chosen position along this curve, the curve reaches a certain height depending on the input value. This position can be a reference for analyzing how the curve behaves in its immediate vicinity.To understand the change in the curve near a particular position, imagine selecting another point slightly ahead along the curve.
404
Microsoft Excel: Median, Quartile range, and Box Plots01:29

Microsoft Excel: Median, Quartile range, and Box Plots

In Microsoft Excel, calculating the median, interquartile range, and creating box plots can help understand the distribution of your data.
Median and Quartile Range: The median is calculated using the formula `=MEDIAN(range)', which provides the middle value of your data set. Quartiles divide your data into four equal parts. To find the first and third quartiles, use ‘=QUARTILE(range, 1)' and ‘=QUARTILE(range, 3)', respectively. The interquartile range (IQR), which...
3.9K