For these project assignments throughout the course you will need to reference the data in the ROI Excel spreadheet. Download it here. Using the ROI data set: For each of the two majors:Draw the scatter diagram of Y = ‘Annual % ROI’ against X = ‘Cost’.Obtain b0 and b1 of the regression equation defined as y ̂ = b0 + b1X and the coefficient of determination (r2) from the Excel regression output. Draw the fitted regression line on the scatter diagram.Calculate the estimated ‘Annual % ROI’ when the ‘Cost’ (X) is $160,000.Test the hypothesis: H0: β1 = 0Ha: β1 ≠ 0Write a paragraph or more on any observations you make about the regression estimates, coefficient of determination, the plots, and the results of your hypothesis tests.Grading Criteria AssignmentsMaximum PointsMeets or exceeds established assignment criteria40Demonstrates an understanding of lesson concepts20Clearly presents well-reasoned ideas and concepts30Uses proper mechanics, punctuation, sentence structure, and spelling10Total100

For this Discussion, you will examine central tendency and variability based on two separate variables. You will also explore the implications for positive social change based on the results of the data. To prepare for this Discussion: Review this week’s Learning Resources and the Descriptive Statistics media program. For additional support, review the Skill Builder: Visual Displays for Categorical Variables and the Skill Builder: Visual Displays for Continuous Variables, which you can find by navigating back to your Blackboard Course Home Page. From there, locate the Skill Builder link in the left navigation pane. Review the Chapter 4 of the Wagner text and the examples in the SPSS software related to central tendency and variability. From the General Social Survey dataset found in this week’s Learning Resources, use the SPSS software and choose one continuous and one categorical variable Note: this dataset will be different from your Assignment dataset). As you review, consider the implications for positive social change based on the results of your data. By Day 3 Post, present, and report a descriptive analysis for your variables, specifically noting the following: For your continuous variable Report the mean, median, and mode. What might be the better measure for central tendency? (i.e., mean, median, or mode) and why? Report the standard deviation. How variable are the data? How would you describe this data? What sort of research question would this variable help answer that might inform social change? Post the following information for your categorical variable: A frequency distribution. An appropriate measure of variation. How variable are the data? How would you describe this data? What sort of research question would this variable help answer that might inform social change?