MthEd 308
buffjessical.xlsm | |
File Size: | 43 kb |
File Type: | xlsm |
I never realized until just this past week in class how useful Excel can be if you know how to use it. Before, I would only consider utilizing it if I needed to create a table or graph. Excel has many more uses though! It was really fascinating to program equations into the cells and have Excel work more like a calculator you created.
cos.layj.xlsx | |
File Size: | 71 kb |
File Type: | xlsx |
nrootjessical.xlsx | |
File Size: | 55 kb |
File Type: | xlsx |
3. Using the spreadsheet we created in class and investigating the effects of the coefficients a, b, c, and d on the cubic graph I found a few interesting characteristics:
4. I worked on this problem for a long time and could not find two numbers that require the spreadsheet to use at least 25 iterations to find the Greatest Common Factor.
- When "a" is positive, the graph has a positive slope, going from the 1st quadrant to the the 3rd quadrant. When "a" is negative, the graph has a negative slope, going from the 2nd quadrant to the 4th quadrant.
- It appears that "b" affects the cubic graph more in the x-direction. As "b" grows larger, it stretches the graph horizontally, and as "b" diminishes, the graph contracts horizontally. The humps in the graph cover more area when "b" is large, and are more linear when "b" is smaller.
- The coefficient "c" changes the height of the hump. If "a" is negative, than a negative "c" creates a more linear looking graph with a smaller hump. Whereas, if "c" were positive in this case the humps would be taller. We get similar results for negative "a".
- "d" shifts the graph up and down along the y-axis. For example, if "d" is +3, the graph shifts up the y-axis three coordinates
4. I worked on this problem for a long time and could not find two numbers that require the spreadsheet to use at least 25 iterations to find the Greatest Common Factor.