Kimberly Lincoln
QNT/275
January 22, 2015
Dr. Juritsa Ford
Business Decision Making Project, Final
After reviewing the Power Point slide, we now have an understanding of what the problem is, why it’s important, what we need to do, what resources we need, and what to expect. Now, through the use of statistics, we can look at the numbers to make a smart business decision to overcome the problem. According to Stine and Foster (2014), statistics "helps you answer questions by providing methods designed to handle variation" (p. 3). We will review data collected, graphs and charts, data analysis, the statistical t-test method, and then interpret the results, which will give us a strong conclusion in order to make the smartest business decision for StandUp Wireless.
Data Collected
The demographic data collected includes two reports, one from El Mirage and the other Surprise, containing the current and prior years for students in each school district who receive the free lunch program. Team B obtained a suitable sample of quantitative data by reviewing the data posted on the school districts websites for Surprise and El Mirage. The school districts post reports for the past four years or more that show demographics and include the number of students receiving the free lunch program. Other data includes a total number of students in the school districts, full-time students, and student/teacher ratio. For the year, 2013, the school district for El Mirage has one thousand six hundred and fifty-three students enrolled and the school district in Surprise has one thousand two hundred and eighty students enrolled. The data is valid and reliable because the data was retrieved from a reliable source: the National Center for Education Statistics, U.S. Dept of Education. Due to the history and reputation of the source, it can be trusted that the source performs due diligence in supplying information and the sample is suitable. The data pulled includes the number of students who receive the free lunch program, because it is one of the ways people in the community are eligible to receive the product. The city that has the most people who qualify for the product will mostly likely have a more positive response toward the product. Therefore, whichever city has a higher number amount of people for the free lunch program, will have a higher number of people who may sign-up for the product offered by StandUp Wireless.
Graphs and Charts
As reflected in the charts below, it is apparent that the city of El Mirage is best place to advertise. The data is staggering and speaks for itself; El Mirage has double the amount of students receiving the free lunch program at sixty-five percent and Surprise has a percent of thirty-two. If we take the mean of the past four years of students receiving the free lunch program, El Mirage is sixty-seven percent, and the mean of Surprise is thirty-two percent. As a result of this data, the team believes that El Mirage will be the best place to advertise going forward in hopes to overcome the problem faced by StandUp Wireless.
Year
# Students
Fulltime Teachers
Student/Teacher ratio
% Free/Disc Lunch
2010
610
30.2
20.2
31.6
2011
943
44.9
20.9
36.7
2012
1119
63.0
17.7
32.7
2013
1280
64.6
19.8
32.0
Year
# Students
Fulltime Teachers
Student/Teacher ratio
% Free/Disc Lunch
2010
1683
74.6
22.5
65.7
2011
1627
78.1
20.8
71.4
2012
1657
72.7
22.7
66.0
2013
1653
75.1
22.0
65.3
Analysis
Based on the information from the charts and graphs, we are able to analyze the data. The percentage of students eligible for free or reduced lunch was collected from www.schooldigger.com. Twenty-four public schools in the city of Surprise, and six public schools in the city of El Mirage. This data is comprised of all public schools in both cities. The mean percentage of students eligible in Surprise was 40.85 percent, while El Mirage had a mean of 77.02 percent. The variance for Surprise was calculated