for michelle lewis only

Math unit 6 discussion

During this unit, you will learn about how to use Excel to create a linear regression equation. Please follow these steps:

Choose any Excel Discussion dataset. Include the name of the dataset. From that dataset, select any two quantitative variables that you suspect will be related (such as age and height for example). What is the name of the dataset you have chosen? Which two variables did you choose?
Next, using Excel, calculate the relationship (r value) between the two variables. Recall that the Excel “formula” for correlation is “=CORREL.” What is the r value for the two variables that you have chosen? Is it positive or negative? Is it strong, medium, or weak? Note that it is best to have an r value that is medium or strong. It is recommended that you try a few different variables until you find two variables with an r value between .5 and 1 (or between -.5 and -1).
Next, use Excel to create a scatterplot for the two variables. You decide which variable will be dependent (y) and which will be independent (x). On the scatterplot, include the “trendline” and the “equation for the line” using Excel options. Attach your scatterplot to your post.
Finally, using the equation of the line that you generated above, plug in any reasonable value for x (your chosen independent variable) and solve the equation for y (your chosen dependent variable). It is up to you to determine which of your two variables is x and which is y. What prediction do you get? Show all your work. In other words, type out the equation, plug in a value for x, and show your solution for y.

Unit 7
 
There are three types of probabilities: theoretical probability, relative frequency probability, and subjective probability. In addition, some data (such as female adult heights) are normally distributed data.
1.   From your own experience either personally or professionally, provide an example of when you have encountered or used relative probability. Start by defining relative probability. Next, describe the example and explain why it is relative probability, rather than theoretical or subjective.
2.   From your own experience either personally or professionally, provide an example of when you have encountered or used subjective probability. Start by defining subjective probability. Next, describe the example and explain why it is subjective probability, rather than relative or theoretical.
3.   Research the Internet to learn more about data that is normally distributed. When normal data are graphed with a histogram, they form a bell-shaped curve. Is normal data symmetric or skewed? What does it mean for data to be skewed left? Name a variable that you would expect to be normally distributed and explain why. For example, female height is normally distributed.