The state of Virginia has implemented a Standard of Learning (SOL) test that all public school students must pass before they can graduate from high school. A passing grade is 75. Montgomery County High School administrators want to gauge how well their students might do on the SOL test, but they don’t want to take the time to test the whole student population. Instead, they selected 20 students at random and gave them the test. The results are as follows:
83    79    56    93
48    92    37    45
72    71    92    71
66    83    81    80
58    95    67    78

Assume that SOL test scores are normally distributed.

1. Compute the mean and standard deviation for these dat
2. Determine the probability that a student at the high school will pass the test.
3. How many percent of students will receive a score between 75 and 95?
4. What score will put a student in the bottom 15% in SOL score among all students who take the test?
5. What score will put a student in the top 2% in SOL score among all students who take the test?

PLEASE USE EXCEL

THANK YOU

1. Questions 10 through 15 refer to the following:

   The following data concerning income and educational attainment for several counties in Alabama were taken from the U.S. Census Website.

   County	% High School Grads	Per Capita Income
   Autauga	87.6	26168
   Chilton	80.1	22045
   Coosa	72.9	18080
   Dallas	79.0	17611
   Elmore	86.8	24711
   Jefferson	89.0	28162
   Lee	88.7	24951
   Lowndes	74.8	18434
   Macon	80.5	18385
   Montgomery	85.5	26255
   Pike	80.0	20180
   Shelby	91.6	34117
   Sum	996.5	279,099
   Sum of Squares	83,144.21	6,772,411,831
   ∑xy	23,475,084.2

   10.Find the least squares regression equation for predicting per capita income using the percentage of high school graduates.

   		y = 419082.121 - 57.439x
   		y = -39729.72 + 758.510x
   		y = -6652.046 + 317.053x
   		y = -18096.537 + 474.365x
   		y = 22417.029 + 127.884x

QUESTION 11

1. Find the sample correlation coefficient between per capita income and percentage of high school graduates.

QUESTION 12

1. Find the value of the t statistic for testing H₀: β₁ = 0 vs. H_A: β₁ ≠ 0.

QUESTION 13

1. What's the p-value for the test statistic in #12?

QUESTION 14

1. Do the data provide significant evidence at the .05 level of a linear relationship between per capita income and the percentage of high school graduates?

   		yes
   		no
   		12
   		robot

QUESTION 15

1. What is the expected change in per capita income associated with a 1% increase in the proportion of high school graduates?

Question 3

In a study conducted on 335 primary school students in a small district in Malaysia, students at primary levels 4-6 were asked which goal in terms of good grades, athletic ability or popularity (being popular in school) was most important to them. A two-way table (Table 3.1) separating the students by their educational levels and goals is shown below:

Table 3.1

a. To investigate possible differences among the students' goals by educational levels, a researcher suggested that it is useful to compute the column percentages. You are required to compute the column percentages and explain the meaning of these percentages. Do the results suggest that there is much of a variation in goals across the three educational levels?                                                                                         

b. The dataset from the same study now divides the students' responses into "Urban," "Suburban," and "Rural" school areas as shown in Table 3.2.You are required to conduct a Chi-Squared test to investigate whether there is an association between school area and the students' goals of getting good grades, athletic ability or popularity as most important to them?

Table 3.2

***Must provide explanation for each question and graph if applicable!!!!

2. Some firms offer workers much more job security than other firms do. Assuming the jobs are otherwise similar, we would expect to see
   1. increased wages to workers in firms with more job security.
   2. decreased wages to workers in firms with more job security.
   3. no relationship between wages and job security.
   4. the direction of the relationship is ambiguous.
3. The average difference in earnings between college and HS graduates in their 30s
   1. is increased by average differences in innate ability.
   2. is decreased by differences in human capital accumulated after leaving school.
   3. would be higher if job benefits were considered.
   4. none of the above.
   5. two or more of the above are correct. (Specify which)
4. How are unemployment rates in the United States related to education?
   1. Unemployment rates are unrelated to education.
   2. Higher levels of education are associated with higher rates of unemployment.
   3. Higher levels of education are associated with lower rates of unemployment.
   4. Unemployment rates are highest for high school dropouts but are unrelated to education for anyone who has a high school degree.
   5. Unemployment rates for high school dropouts and high school graduates are roughly equal and are less than the overall unemployment rate of college graduates.
5. Which of the following is NOT a plausible result of an increase in the generosity of benefit payments received under workers’ compensation laws?
   1. The proportion of fraudulent to legitimate claims will increase.
   2. Employers will attempt to entice their workers back to work earlier.
   3. Employers will employ more lax workplace safety standards.
   4. Workers will be more likely to ignore safety standards.
   5. Employers will hire fewer workers.

. In a large corporation the mean entry level salary is $27,000 with a standard deviation of σ = 6,000. The entry level salaries for a random sample of 15 employees with only high school degrees is X ̅ = $24,100 . Do people with only high school degrees earn less than the rest of the company? Conduct a one-tailed hypothesis test with  = .05.

2a. The hypothesis test should be... (highlight one) (1 point) a) one-tailed (directional) b) two-tailed (non-directional) 2b. According to your answers above, conduct the hypothesis test. STEP 1: State your hypotheses in both words and symbols. Be sure to clearly label your null and research (alternative) hypotheses. (4 points)

In words:

In symbols:

STEP 2: Find the critical value. (2 points)

STEP 3: Compute the appropriate test-statistic. (4 points)

STEP 4: Evaluate the null hypothesis (based on your answers to the above steps). REJECT or FAIL TO REJECT (highlight one) (1 point) Which is the best conclusion, according to your decision in

STEP 4? (Highlight one) (1 point)

a. People with only high school degrees make the same amount of money as the rest of the population.

b. People with only high school degrees make significantly more money than the rest of the population.

c. People with only high school degrees make significantly less money than the rest of the population.

2c. IF your decision had been to reject the null, what is the probability that you made a Type I error in this problem? (1 point

Question 3

In a study conducted on 335 primary school students in a small district in Malaysia, students at primary levels 4-6 were asked which goal in terms of good grades, athletic ability or popularity (being popular in school) was most important to them. A two-way table (Table 3.1) separating the students by their educational levels and goals is shown below:

Table 3.1

1. To investigate possible differences among the students' goals by educational levels, a researcher suggested that it is useful to compute the column percentages. You are required to compute the column percentages and explain the meaning of these percentages. Do the results suggest that there is much of a variation in goals across the three educational levels?   
2. The dataset from the same study now divides the students' responses into "Urban," "Suburban," and "Rural" school areas as shown in Table 3.2. You are required to conduct a Chi-Squared test to investigate whether there is an association between school area and the students' goals of getting good grades, athletic ability or popularity as most important to them?

Table 3.2

The registered nurse at the local middle school is responsible for health promotion and disease prevention of the seventh and eighth grade students. The nurse provides screenings and illness care as well as assurance that immunizations are up to date with documentation on file. Nurses who work with the school population are aware of their significant influence on the students and the importance of teaching ways to develop and maintain good health habits at a young age. Nurses hope the students will carry the information home and have an influence on the health of the families as well.

1. The mother of a 13-year-old boy approaches the school nurse because she is concerned about her son’s weight. She states that she approached his pediatrician about the issue and felt dismissed. The nurse assesses the height and weight of the boy and determines that he is above the 95th percentile for his age. What are the next steps for the school nurse?

a. Educate about a healthy diet but tell the mother that her son is too young to be concerned about his weight.

b. Place the student on a diet and exercise plan with a goal of losing 2 to 3 lb per week.

c. Educate about a healthy diet and physical activity and instruct the mother that her son should maintain his current weight while he continues to increase his height.

d. Inform the mother that she should have been more concerned before her son reached puberty.

2. The school nurse provides education to the students about injury prevention measures. What educational topic is shared with the middle school age?

a. Bicycle safety

b. Poisoning prevention

c. Violence

d. Motor vehicle safety

3. A student presents to the nurses’ office with a severe allergic reaction to a bee sting. What is the primary role of the nurse in delivering emergent care to the child?

a. Call the parents to obtain phone consent for treatment.

b. Provide emergency care and then inform the parents.

c. Call the child’s primary care physician to obtain orders.

d. Send the student to the nearest emergency department.

4. A parent who fails to ensure that their child attends school is exhibiting

a. acts of commission.

b. psychological abuse.

c. acts of demission.

d. acts of omission.

Use the Chi-Square option in the Nonparametric Tests menu to answer the questions based on the following scenario. (Assume a level of significance of .05 and use information from the scenario to determine the expected frequencies for each category).

Scenario: During the analysis of the district data, it was determined that one high school had substantially higher Graduate Exit Exam scores than the state average and the averages of high schools in the surrounding districts. To better understand possible reasons for this difference, the superintendent conducted several analyses. One analysis examined the population of students who completed the exam. Specifically, the superintendent wanted to know if the distribution of special education, regular education, and gifted/talented test takers from the local high school differed from the statewide distribution. The obtained data are provided below. Description Special Education* Regular Education Gifted/Talented Number of students from the local high school who took the

*For purposes of testing, special education includes any student who received accommodations during the exam.

1. If the student distribution for the local high school did not differ from the state, what would be the expected percentage of students in each category?

2. What were the actual percentages of local high school students in each category? (Report final answer to two decimal places)

3. State an appropriate null hypothesis for this analysis.

4. What is the value of the chi-square statistic?

5. What are the reported degrees of freedom?

6. What is the reported level of significance?

7. Based on the results of the one-sample chi-square test, was the population of test taking students at the local high school statistically significantly different from the statewide population?

8. Present the results as they might appear in an article. This must include a table and narrative statement that reports and interprets the results of the analysis.

Note: The table must be created using your word processing program. Tables that are copied and pasted from SPSS are not acceptable.

Based on the following case study answer two of the questions

a. Dell is a pioneer in stimulating exchanges with customers through social media. With reference to Dell, discuss the differences between e-marketing and traditional marketing activities.

b. As more companies are moving towards green businesses, should Dell adopt a similar strategy to market its products? Justify your answer

Dell Direct and Not-So-Direct Case Study:

When Michael Dell started his Texas-based computer business in 1984, he chose a distribution strategy that was radically different from that of other computer marketers. Instead of selling through wholesalers and retailers, the company dealt directly with customers. This kept costs low and allowed Dell to cater to customers' needs by building each computer to order. Using a direct channel also minimized inventory costs and reduced the risk that parts and products would become obsolete even before customers placed their orders, a constant concern in high-tech industries.

By 1997, Dell's website alone was responsible for $1 million a day in sales. Relying on the strength of its online sales, catalogs, and phone orders, Dell expanded beyond the United States and added new products for four target markets: consumers, large corporations, small businesses, and government agencies. Meanwhile, Apple, Hewlett-Packard, and other competitors were reaching out to many of the same segments with a combination of direct and indirect channels. Apple Stores, for example, proved to be major customer magnets and gave a significant boost to sales of Macintosh computers and other Apple electronics. Hewlett-Packard forged strong ties with value-added resellers (VARs), intermediaries that assemble systems of computers, servers, and other products customized to meet the special needs of business buyers.

Although Dell tested retail distribution on a number of occasions, it never let the experiments go on too long. In the 1990s, it tried selling PCs through a few big U.S. retail chains, but soon discontinued the arrangement because the profit margins weren't as healthy as in the direct channel. Later, it opened a series of branded retail kiosks in major U.S. markets to display its products and answer customers' questions. Unlike stores, however, the kiosks didn't actually sell any-thing: Customers could only place orders for future delivery. Dell ultimately closed the kiosks down. By 2007, with competitors coming on strong, Dell was ready to rethink its worldwide channel strategy. As convenient as online shopping was for many U.S. computer buyers, it was much less popular in many other countries. To gain market share domestically and internationally, Dell would have to follow consumers into stores, malls, and downtown shopping districts. The company began selling a few models through Walmart's U.S. stores, Carphone Warehouse's U.K. stores,. Bic Camera's Japanese stores, and Gome's Chinese stores. In addition, it opened Dell stores in Moscow, Budapest, and other world capitals.
By 2010, sales through retailers had gained enough momentum that Dell sought out other retail deals. In another channel change, it began selling through VAR partners that serve small- and medium-sized businesses and lined up wholesalers to distribute its products in Europe, Latin America, and elsewhere. When Dell introduced a new line of smart-phones, it needed a new channel arrangement to reach buyers. Therefore, it arranged for cell phone carriers such as AT&T to sell the new models to their customers.

As successful as Dell has been in revamping its indirect channels, selling directly to customers remains a top priority. Dell invites orders around the clock through Web pages tailored to the needs of each 'target market. It also maintains an online outlet store to sell 4 discontinued and refurbished products. It mails millions of catalogs and direct-mail pieces every year. And its sales force calls on government officials and big businesses that buy in volume. Dell's website notes, with pride, that the 10 largest U.S. corporations and five largest U.S. commercial banks "run on Dell."

Moreover, the company is a pioneer in stimulating exchanges with customers through social media. Dell has 139,000 fans on Facebook, for example, and regularly posts offers that drive customers to its various websites. It's become a pioneer in selling directly to customers via the micro blog site Twitter. In less than three years, it generated $6.5 million in revenue from sales transactions that originated on Twitter. That may be a tiny sliver of Dell's $53 billion in annual revenue, but it demonstrates the company's flexibility in adapting to shifts in customer behavior and environmental forces, such as technological advances. With market share and profit-margin challenges still facing the company, and global demand just picking up steam after a long, difficult recession, watch for Dell to make more channel adjustments in the coming years.