Quantitative Reasoning I Project: Creating Visuals from Data The purpose of this assignment is to have you practice creating visuals using the data from the topic you chose in Week 2. Creating charts and trendlines are important skills used in many careers. Watch How to Create Trendlines and Scatterplots in Excel®. Watch Week 4 Lynda.com® Video: Data-Analysis Fundamentals with Excel. Create at least two visuals using your data from the data you chose in Week 2. Week 4 Lynda.com® Videos: Office 365®: Excel® Essential Training https://www.lynda.com/ 1. Create one scatter plot of the data, and apply a linear model (also known as a regression) in Excel®. Include the equation, R2 value, and prediction value on the visual. 2. Create one scatter plot of the data, and apply an exponential model in Excel®. Include the equation, R2 value, and prediction value on the visual. 3. Determine whether the linear or the exponential model is a better representation of your data to base your prediction on. Explain why the model you chose is a better representation of your data. Hints for Making an Effective Chart: • • • • Decide why you are making a chart from this data. Title each chart so that it aligns with the data and selected model. Create descriptive labels for both the x- and y axes. Resize the chart as needed so it can be viewed easily. Week-2 Quantitative Reasoning, I Project: Selecting a Topic For this assignment, I chose the topic of social sciences. The issue being addressed in the topic is prediction of the student test performance depending on hours spend sleeping. Considering this scenario, I will be required to evaluate the number of sleeping hours for the different students followed by a review of the average test scores which they obtain in the following day (Greenleaf, 2006). Through analyzing the data findings, I will be able to estimate the number of hours which students need to spend sleeping in order to score high on their exam tests. I chose the topic of social sciences for two reasons: - Firstly, the data findings will help in determining the number of hours which my children need to sleep a day before sitting for their exam tests in order to score high. Secondly, the topic of social sciences is highly appealing to me since my household has a total of five children who are all attending school. Therefore, the topic will help in attaining academic success among my family members. I’m hoping to discover the exact number of hours which students need to spend in sleeping throughout their academic life. The data findings are meant to aid students towards achieving the best score academically. References Greenleaf, F. (2006). Quantitative reasoning. New York: McGraw-Hill. Quantitative Reasoning I Project: Creating Visuals from Data The purpose of this assignment is to have you practice creating visuals using the data from the topic you chose in Week 2. Creating charts and trendlines are important skills used in many careers. Watch How to Create Trendlines and Scatterplots in Excel®. Watch Week 4 Lynda.com® Video: Data-Analysis Fundamentals with Excel. Create at least two visuals using your data from the data you chose in Week 2. Week 4 Lynda.com® Videos: Office 365®: Excel® Essential Training https://www.lynda.com/ 1. Create one scatter plot of the data, and apply a linear model (also known as a regression) in Excel®. Include the equation, R2 value, and prediction value on the visual. 2. Create one scatter plot of the data, and apply an exponential model in Excel®. Include the equation, R2 value, and prediction value on the visual. 3. Determine whether the linear or the exponential model is a better representation of your data to base your prediction on. Explain why the model you chose is a better representation of your data. Hints for Making an Effective Chart: • • • • Decide why you are making a chart from this data. Title each chart so that it aligns with the data and selected model. Create descriptive labels for both the x- and y axes. Resize the chart as needed so it can be viewed easily. Week-2 Quantitative Reasoning, I Project: Selecting a Topic For this assignment, I chose the topic of social sciences. The issue being addressed in the topic is prediction of the student test performance depending on hours spend sleeping. Considering this scenario, I will be required to evaluate the number of sleeping hours for the different students followed by a review of the average test scores which they obtain in the following day (Greenleaf, 2006). Through analyzing the data findings, I will be able to estimate the number of hours which students need to spend sleeping in order to score high on their exam tests. I chose the topic of social sciences for two reasons: - Firstly, the data findings will help in determining the number of hours which my children need to sleep a day before sitting for their exam tests in order to score high. Secondly, the topic of social sciences is highly appealing to me since my household has a total of five children who are all attending school. Therefore, the topic will help in attaining academic success among my family members. I’m hoping to discover the exact number of hours which students need to spend in sleeping throughout their academic life. The data findings are meant to aid students towards achieving the best score academically. References Greenleaf, F. (2006). Quantitative reasoning. New York: McGraw-Hill.
Purchase answer to see full attachment