Explain if you plan to conduct a regression analysis or correlation or t-test, and the measurements you plan to use You will be utilizing descriptive analysis and using descriptive statistics within Data Analysis in Excel (mean, median, standard deviation analysis, minimum, maximum).

Words: 1102
Pages: 5
Subject: Premium Writing

2. Explain how you plan to test your hypothesis
3. Identify how you plan to organize your data
4. Identify how you plan to calculate your statistical data
5. Identify how you plan to investigate associated dispersions
6. Explain if you plan to conduct a regression analysis or correlation or t-test, and the measurements you plan to use
You will be utilizing descriptive analysis and using descriptive statistics within Data Analysis in Excel (mean, median, standard deviation analysis, minimum, maximum). Depending on your data, you may also be utilizing some of the following to analyze your data: (a) Correlation (b) Linear Regression or (c) t-test.
Below are resource videos on these topics:
Correlations with Excel Video: How to Find Correlation in Excel With the Data Analysis Toolpak
Linear Regression with Excel Video: Excel – Simple Linear Regression
T-Test with Excel Video: How to Do a Two Sample T Test Paired Two Sample for Means in Excel 2013
Using Excel for descriptive Statistics Video: Descriptive Statistics in Excel with Data Analysis Toolpak

Appendix A – Suggested Websites for Data Sets
Data.gov: http://data.gov
US Census Bureau: http://www.census.gov/data.html
Open Data Network: https://www.opendatanetwork.com/
European Union Open Data Portal: http://open-data.europa.eu/en/data/
Data.gov.uk: http://data.gov.uk/
Canada Open Data: https://open.canada.ca/en
The CIA World Factbook: https://www.cia.gov/library/publications/the-world-factbook/
Healthdata.gov: https://www.healthdata.gov/
UNICEF: https://www.unicef.org/reports
World Health Organization: http://www.who.int/en/
Amazon Web Services public datasets: http://aws.amazon.com/datasets
Google Public Data Explorer: https://www.google.com/publicdata/directory
Gapminder: http://www.gapminder.org/data/
National Climatic Data Center: http://www.ncdc.noaa.gov/data-access/quick-links#loc-clim
Dr. John Rasp’s Statistics Website: http://www2.stetson.edu/~jrasp/data.htm
Part 2
Watch the following Ted Talk, “Improve your Life with Probability” by Spencer Greenberg
Weblink: TEDxBlackRockCity – Spencer Greenberg – Improve Your Life With Probability
After watching the video, discuss the questions below:
What are your reactions to the ideas presented?
Do you think this is a practical way to view the world? Why?
Give an example of a situation in your personal or professional life where thinking in terms of probability helped you more than a dichotomous way of thinking. 150 words and ask three questions about this video. 150 words
MATH309 Portfolio Project Grading Rubric
Criteria Level 4 Level 3 Level 2 Level 1 Points
Statement of Problem
10 points 10 points
Problem is in students’ degree field, clearly stated, and relates to the topic. 8 points
Problem is clearly stated and relates to the topic. 6 points
Problem is clearly stated. 0 points
Problem is not clearly stated.
Literature Review
20 points 10 points
Student locates four or more sources and objectively discusses their findings and relationship to study. 8 points
Student locates three sources for the literature review and discusses their findings and relationship to the study. 6 points
Student locates two sources for and discusses their findings. 0 points
Student fails to locate any sources.
Goal Statement
5 points 5 points
Goal statement is interesting, clear, and relates to the topic. 4 points
Goal statement is clear and relates to the topic. 3.5 points
Goal statement is clear. 0 points
Goal statement is not clear.
Research Questions
10 points 10 points
Provides a series of interesting research questions and clearly identifies each of the variables and their potential influence on other variables. 8 points
Provides a series of research questions and identifies some variables along with some of their potential influence on other variables. 6 points
Provides some research questions and identifies a few variables. 0 points
No research questions provided
Methodology
10 points 10 points
Hypothesis is interesting, plan to test hypothesis is effective, data organization is efficient, plan to calculate statistical data is effective, plan to investigate associated dispersions is effective, regression analysis plan is effective, and/or the measurements are appropriate. 8 points
Hypothesis is effective, plan to test hypothesis is provided, data organization is evident, plan to calculate statistical data is presented, plan to investigate associated dispersions is indicated, regression analysis plan is offered, and/or the measurements are provided. 6 points
Hypothesis is ineffective, plan to test hypothesis is ineffective, data organization is ineffective, plan to calculate statistical data is ineffective, plan to investigate associated dispersions is ineffective, regression analysis plan is ineffective, and/or the measurements are inappropriate. 0 points
No hypothesis is provided, there is no plan to test the hypothesis, data organization plan is not provided, statistical processes are not provided, and no measurements are offered.
Data Analysis
40 points 40 points
Data analysis and Excel work is structured in column format, answers identified, and columns labeled, and very thorough, and appropriate to the topic. Analysis justifies and support conclusions. 32 points
Data analysis and Excel work is good and reasonably complete. Conclusions are consistent with analysis. 28 points
Analysis is rudimentary at best. Conclusions are present but not well supported by the analysis. 0 points
Analysis is inappropriate or missing. Conclusions are invalid or missing.
Conclusion
10 points 10 points
Conclusion and Reflection are interesting, clearly stated, related to the topic, and addresses all stated questions in the supplied assignment prompt. 8 points
Conclusion and Reflection are clear, mostly relates to the topic, and addresses most stated questions in the supplied assignment prompt. 6 points
Conclusion and Reflection are somewhat clear, somewhat relates to the topic, and addresses some of the stated questions in the supplied assignment prompt. 0 points
Conclusion and Reflection are unclear, does not relate to the topic, and addresses few if any of the stated questions in the supplied assignment prompt.
Grammar, Mechanics, and Information Literacy
5 points 5 points
Few, if any, grammatical or mechanical errors. All supplied data and sources are appropriate and properly documented in APA format. 4 points
Some grammatical and mechanical errors. Some supplied data and sources are appropriate and properly documented in APA format. 3.5 points
Many grammatical and mechanical errors. Most supplied data is not appropriate and is not properly documented in APA format. 0 points
Grammatical and mechanical errors seriously inhibit the project’s effectiveness. Nearly all or all of the supplied data is inappropriate and and is not properly documented in APA format.
Instructor Comments: Total Points: