Scatter Plot, Linear Regression and R Value
Introduce yourself in the class. Share where you work or plan to work after completing your program, your family, and any hobbies or special interests. Also tell us why you are taking this course and what you hope to gain from obtaining your degree. In addition, please take a look at the course objectives in the syllabus and discuss the relevance to your career goals.
MATH120 Introduction to Statistics
Week 2 Forum
Scatter Plot, Linear Regression and R Value
Open excel
In one column enter 8 heights for 10 year old boys (inches) and in the second column enter 8 weights for 10 year old boys (pounds). Ten year old boys height ranges from 42 inches to 62 inches while the weight ranges from 60 to 90 pounds. You can make these up as long as they are reasonable if you do not have access to any data. We want to see if there is a correlation.
Move your mouse to put a box around the numbers.
From the insert menu select scatter or the chart that says scatter and then select the chart at the top left on the dropdown
Click on one of the points
Select Add Trendline (Note you may need to add Trendline and then click on the line to format Trendline)
The default radio button is linear, keep it checked
Check display equation on chart and click on the display r-squared value
The equation is your least squares line
On the least squares line the slope is in front of the x value. Also, you can look at the slope of the scatter plot to see if the slope is positive. This will let you know whether to make the r value positive or negative when you take the square root of r^2.
If the r^2 value is say .0382 then you will click on an excel cell and type
=.0382^.5
Note the ^ key is above the 6 key
This will be your r value and you will make it negative if your slope is negative otherwise leave it positive.
If you have a different version of excel then you may want to search to see how to form a trendline. These instructions work with Office 365 and Office 2010.
Then follow these instructions:
Attach your excel worksheet with your scatter plot, r value and regression line along with your post if possible. What did you get for your regression line? What was your r value? What did this tell you?
What would be a scenario where you might need to use this application?
Be sure to comment on at least 2 classmates.
MATH120 Introduction to Statistics
Week 3 Forum
Conditional Probabilities
Finding a conditional Probability:
Example
Let’s look at a standard deck of 52 cards.
What is the probability of getting 2 kings assuming that the first one is not replaced?
4/52 * 3/51 = 1/13*1/17= 1/221
What is the probability of getting 2 kings assuming that the first one is replaced?
4/52 * 4/52 = 1/13 * 1/13 = 1/169
Instructions
Now for your main post do a similar problem using with replacement and without replacement. You can use a card problem as long as it is not 2 kings. Try your best to be original. This may not be 250 words. That is fine. Do not solve your own problems. Leave them for your classmates to work.
For your response pick 2 classmates. On each post copy their problem, then show your work explaining how you worked each problem, and then show your answer. Of course there will be more than one comment on each person’s work. Stay positive when replying.
MATH120 Introduction to Statistics
Week 4 Forum
Binomial
Review the criteria for a binomial in the announcements before selecting your problem.
Example
a) On this example we will examine the probability a couple who has 8 children and has exactly 5 boys.
b) Next we will look at the probability that they have more than 5 boys.
c) Finally we will look at the probability that they have at most 5 boys.
Assume a .5 chance of having a boy.
Solution can be solved using excel.
a) On this example we will examine the probability a couple who has 8 children has exactly 5 boys.
Type this in an excel cell
=binom.dist(5,8,.5,False)
and then hit enter
.21875 would be the answer
b) Next we will look at the probability that they have more than 5 boys.
Type this in an excel cell
=1-binom.dist(5,8,.5,True)
and then hit enter
.144531 would be the answer
c) Finally we will look at the probability that they have at most 5 boys.
Assume a .5 chance of having a boy.
Type this in an excel cell
=binom.dist(5,8,.5,True)
and hit enter
.855469 would be the answer
Instructions: For your post you will make up a problem similar to this example. Try to have at least 3 scenarios. You will not solve your own problem.
Then you will answer 2 classmates problems. Copy the question, type the excel formulas in an excel spreadsheet and attach it to your post so your professor and classmates can check your work. Then write a brief summary after the problem you copied in your post.
MATH120 Introduction to Statistics
Week 5 Forum
Midterm Reflection
Now that we have passed the half-way mark of the class, tell us in at least 250 words what you think about learning math online?
Name at least one thing that you really enjoy about the class (come on, there must be something!) and at least one improvement that could make this class even better. Feel free to editorialize!
Also, this is a good time to make a “keep-quit-start” resolution.
What are you doing to help yourself learn in this class that you are going to keep doing because it’s working?
What are you doing that is hindering you from learning in this class that you are going to quit doing?
What do you think will help you improve your learning in this class that you are going to start doing?
Be sure to respond to 2 classmates. Try to keep the conversation going.
MATH120 Introduction to Statistics
Week 6 Forum
Main Post
Assuming .05 as your alpha value, make up a problem similar to this one. Make up 36 gas prices for your example. Use price values in your list that some you made up and be sure they are similar to the prices you have had in your area. List the values in your post.
Instructions for your response. You will respond to at least 2 classmates.
In your response, copy the original problem, describe what you did and give the mean, standard deviation and confidence interval. Then attach the excel spreadsheet below so students and the professor can check your work.
Example below:
First find the mean. List all 36 gas prices in cells A1 to A36 in your excel spreadsheet.
On a different cell type in =average(A1:A36) and the hit enter to find the average
Assume your answer is 2.65
On a different cell type in =stdev.s(A1:A36) or =stdevA(A1:A36) and enter to find the standard deviation
Assume your answer is .43
Then type this in an excel cell =confidence.norm(.05,.43,36) and hit enter. This is the E value
So take the mean of 2.65 and you have (2.65-E, 2.65+E) for your confidence interval
Formula you used above for the confidence interval:
The formula is E= zsubc * sigma / sqrt n
Where the left hand endpoint is xbar – E and the right hand endpoint is xbar + E
MATH120 Introduction to Statistics
Week 7 Forum
Hypothesis Test
Read the sections on Hypothesis Testing in your book.
Click on these links
http://college.cengage.com/mathematics/blackboard/shared/content/video_explanations/video_wrapper.html?filename=v01090a
http://college.cengage.com/mathematics/blackboard/shared/content/video_explanations/video_wrapper.html?filename=v01090b
http://college.cengage.com/mathematics/blackboard/shared/content/video_explanations/video_wrapper.html?filename=v02262a
Think of an application where you can use hypothesis testing to test a premise. Use .05 for your alpha and give the scenario. Set up the problem, solve it and state your conclusions. See the example below. Then respond to at least 2 classmates.
First post: First summarize the 3 videos and make a note of what you learned. Then create your own hypothesis test. For instance, XYZ car company boast that it’s new car Eco Auto gets at least 59 miles to the gallon. Given a sample mean of 57 and a standard deviation of 3.5 where 35 people were tested, find the z value and p score. Hint: Use the P value calculator in the announcements to find the p score. Note: On this one you do not need to attach an excel spreadsheet.
Student Response:
Ho: µ>=59
Ha: µ<59
You can put this in excel or your calculator
= (57-59)/(3.5/35^.5)
=-3.38
Using the z to p value calculator
https://www.socscistatistics.com/pvalues/normaldistribution.aspx
with α=.05, 1 tailed test and z=-3.38, you get
p=.000362
or enter this in excel
=norm.dist(57,59,3.5/35^.5,true) and hit enter
.000362
This is the z value and in this case the p value
If you have a 2 tailed- test, then multiply the value you get by 2.
and hit enter
Since p < .05, you reject the null.
You will want to respond to 2 classmates. Keep the conversation going by mentioning the video and tell what you learned. Also mention how the hypothesis test helped you.
Instructions: Your initial post should be at least 250 words. Please respond to at least 2 other students. Responses should be a minimum of 100 words and include direct questions.
MATH120 Introduction to Statistics
Week 8 Forum
Course Comments
In this last discussion question, please identify your favorite topic covered during this course and explain why you chose this topic. Then let us know how you liked the course.
In addition, here are some additional ideas to think about that relate to your future courses. It’s always good to think about what your “next steps” will be after this course, and how those next steps will help get you to your degree and professional goals. Feel free to include comments about these items, or not, as you see fit.
What degree are you working towards?
What is your progress so far in accomplishing your educational goals?
Why did you choose these courses?
What next course(s) will you choose and why?
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
