StatCrunch logo (home)

Report Properties
Owner: almiksch
Created: Nov 26, 2016
Share: yes
Views: 391
Tags:
 
Results in this report
 
Data sets in this report
None
 
Need help?
To copy selected text, right click to Copy or choose the Copy option under your browser's Edit menu. Text copied in this manner can be pasted directly into most documents with formatting maintained.
To copy selected graphs, right click on the graph to Copy. When pasting into a document, make sure to paste the graph content rather than a link to the graph. For example, to paste in MS Word choose Edit > Paste Special, and select the Device Independent Bitmap option.
You can now also Mail results and reports. The email may contain a simple link to the StatCrunch site or the complete output with data and graphics attached. In addition to being a great way to deliver output to someone else, this is also a great way to save your own hard copy. To try it out, simply click on the Mail link.
Week 12
Mail   Print   Twitter   Facebook

The dependent variable is "Per Pupil Spending, Public K-12 ($)."  The three independent variables I choose are: "State Per Capita GDP ($)," "State Spending on Higher Education ($ per capita)," and "Population under 18%."  I choose each of these variables because I predicted that each would have atleast a moderatly strong relationship to the dependent variable ("Per Pupil Spending, Public K-12 ($) ). I also predicted that states with lower averages on "State GDP" and "State Spending on Higher Education"  would have lower "Per Pupil Spending," and the opposite for high values of those two independent varibles. I predict a postive relationship for "Under 18" and "Per Pupil Spending;" the higher perceptage of children, the higher the educational spending on K-12.  The Correlation matrix summarizes the findings with a -1 through 1 system, indicating the strength and direction of the relationships. I will discuss the relationship of each independent variable with the dependent variable, and how well my predicts hold up to the data, individually, with the scatterplots. 

Result 1: Correlationweek12   [Info]
Correlation matrix:
Per Pupil Spending, Public K-12 ($)State Per Capita GDP ($)State Spending on Higher Education ($ per capita)
State Per Capita GDP ($)0.59150071
(<0.0001)
State Spending on Higher Education ($ per capita)-0.16270724
(0.2589)
-0.14019542
(0.3315)
Population under 18 (%)-0.54518119
(<0.0001)
-0.13639774
(0.3449)
0.012105457
(0.9335)

 

 "State Per Capita GDP ($)" and "Per Pupil Spending, Public K-12 ($)" show a strong, postive relationship. The Scatterplot shows this as well (as the Correlation matrix), but shows in more detail where points fall. The findings do fit my original predict that as State GDP goes up, so will Per Pupil Spending.  I was suprised that most states seem to be towards the middle-low on both variables, and most states fall between 12,000 Per Pupil Spending and 45,000 State GDP. 

Result 2: CapitaGDPstat   [Info]
Right click to copy

 

"State Spending on Higher Education ($ per capita)" and "Per Pupil Spending" shows a weak to weak moderate, negative relationship. The near-flat and negative pointing line on the scatterplot also shows this. I was very suprised that this relationship was weak because I had assumed states that invested more into Higher Education would invest as much, if not even more into Public K-12 education; and, states that cut Higher Education would have likely also have cut Public K-12 education (such as Wisconsin). The states being all over the graph also was as suprising as the weak relationship these variables produced. It does seem from the points (alone) being so scattered that there may be even no relationship, so considering the scatterness of the points, a weak relationship is indicated as well. 

Result 3: StateSpendstat   [Info]
Right click to copy

 

"Population under 18 (%)" and "Per Pupil Spending" shows a negative, strong relationship. While I had predicted a strong relationship, the negative pattern does make sense upon further reflection. Prehaps the more children a state has, the less it is able to spend on each child in the public school system because the state has to divide educational funds by more than a state with fewer children.  A lot of points are clustered right on the mean line or right below. 

Result 4: Less18stat   [Info]
Right click to copy

 

HTML link:
<A href="https://www.statcrunch.com/5.0/viewreport.php?reportid=65200">Week 12</A>

Comments
Want to comment? Subscribe
Already a member? Sign in.

Always Learning