1. A clinical psychologist has noted that autistic children seem to respond to treatment better if they are in a familiar environment. To evaluate the influence of environment, the psychologist selects a group of 30 autistic children who are currently in treatment and randomly divides them into three groups. One group continues to receive treatment in the clinic as usual. For the second group, treatment sessions are conducted entirely in the child’s home. The third group gets half of the treatment in the clinic and half at home. After 6 weeks, the psychologist evaluates the progress for each child. The high scores indicate better progress. Do the data indicate any significant differences between the three settings on mean progress scores? Test at the .05 level of significance (α = .05)

Data

1. (Add the SPSS output (descriptive and F tables) to the preformatted file. Double check to see if you enter the data correctly and if you label the values (1=Clinic, 2=Home, 3 = Clinic/Home).
2. Compare the three means in “Descriptives” table. What conclusion can you draw about the mean differences across three groups?
3. Type your conclusion with APA format (step 4 of hypothesis testing), including an interpretation of η² .

Food Lion Inc. would like to investigate the feasibility and future prospects of setting up stores in Denton County. Food Lion has provided you with a sample from a database of household financial variables. They would like you to use regression techniques to predict the monthly expenditure on groceries, of families who either rent or own their homes in Denton. The sample contains 100 records. The various fields in the sample are:

Income1 Þ Annual income of head of household or primary wage earner

Income2 Þ Annual income of secondary wage earner

Famlsize Þ Size of family (number of people permanently residing in the household)

Ownorent Þ 1 if household is owned; 0 if it is rented

Autodebt Þ Automobile related debt pending for wage earners in the household

Hpayrent Þ Household mortgage payment or rent per month

Groc Þ Monthly expenditure on groceries

Loc Þ 1 = East Denton (E); 0 = West Denton(W); -1 = North Denton (N); 2 = South Denton (S)

For this assignment you will be given minimal instructions since, having completed the first three assignments, you should now be quite familiar with Excel functions and pull down menus.

1. The sample data are contained in a file named Assgt#4.xls to be found in the folder Excel Assignments for All Sections. Download the files from the folder onto a disk.

2. Import the data into the first nine columns (A-I) of your spreadsheet.   The first row contains labels for the variables in the order outlined in the data description. The table below illustrates how the first 10 data records should look, after this step is completed.

3. Insert three columns prior to the column labeled “Groc”. In these columns, create three logical (dummy) variables to represent the four locations. You may use the IF function from the pull down menu, to do this. Please follow the illustration below, where: ED=1, if record is for East Denton; WD=1, if record is for West Denton; and SD=1, if the record is for South Denton (thus North Denton representing the base). After the creation of the dummy variables, the first 11 records should look as shown below.

4. Conduct the regression analysis with Groc as the dependent variable (Y) and Income1 (X1), Income2 (X2), Ownorent (X3), Autodebt (X4), Famlsize (X5), and Location variables (X6 through X8) as the independent variables at 1% level of significance.   Use the Regression tool accessed from the Data Tab/ Data Analysis (in 2003 use Tools/Data Analysis) pull-down menu. Check only the labels box and specify that you want the output in cell M1. (Make sure that you enter “Confidence Level = 99%”).   Also, make sure to check the Standardized residuals box to obtain outlier information. A partial output is shown below for your guidance.

4. By substituting appropriate values directly into the sample regression equation given in your output generate a point estimate for (Alternatively, you may use the TREND function from the pull down menu, and follow directions given in Excel or use the KPK macro to run regression and for prediction as shown in class):

a) the monthly Grocery Bill for a family of 4 living in a rented home in South Denton, whose primary income is $42,457 and with the secondary wage earner having an income of $10000, and Autodebt is $6,000

b) the monthly Grocery Bill for a family of size 7 living in a home in the North Denton that is owned, whose primary income is $35,000 with the secondary wage earner having an income of $25,000, and Autodebt is $10,000.

Details on the trend function can be found by clicking the fx icon on the toolbar then selecting statistical and trend. The new values for Income1, Income2, Ownorent, Autodebt, Famlsize, and Location variables can be placed in convenient cells in the two rows below your regression output and the point estimates for Groc evaluated in the adjacent cells.

Use the output from the regression analysis and trend function to answer the following questions.

A. Write one to three sentences to interpret the meaning of your model’s R-square value.  

B. Conduct an F test for the regression model containing the eight independent variables, at the 1% significance level. State the null and alternative hypotheses, the decision, reason for the decision, and a conclusion.

C. Conduct a t-test, at the 1% significance level, for the usefulness of the dummy (indicator) variable Ownorent. State the null and alternative hypotheses, the decision, reason for the decision, and a conclusion.

D. Conduct a t-test, at the 1% significance level, for the usefulness of the variable Income2. State the null and alternative hypotheses, the decision, reason for the decision, and a conclusion.

E. State which of the eight X (independent) variables are statistically significant and which ones are not, at the 1% significance level.

F. Write one or two sentences on the interpretation of the coefficient of each of the six independent variables, making specific reference to the value of each coefficient given by your model.

Experiential Exercise

As you work this assignment think about the following questions. Then form a team of 3 to 5 and discuss each of the following. You can engage in this discussion by meeting or your group can use a Wiki to engage in an online discussion. Instructions for setting up a Wiki are provided on the excel assignment page of our course web site.

What wording tells you the alternative and null hypothesis?

What wording tells you the type of statistical test to perform? For example, is a z or t statistic appropriate?

What wording tells you that this is a one or two tail hypothesis test?

What were the steps you used to obtain the calculated value of the test statistic?

What were the steps you used to obtain the critical value of the test statistic?

How do you use the calculated and critical value to make a statistical decision about this test?

How do you obtain the p value for the test statistic?

How do you use the p value and the level of significance to make a statistical decision about this test?

How does the result of your test relate to the statistical significance of your findings?

What managerial implications can you conclude from the results of your test?

To be ready for the “Excel Quiz 43” HLS Web Test you should prepare the following:

1. A printout of the regression analysis

2. The results of the prediction/estimation of Groc (computed directly or by using the trend function) in the two rows immediately below the regression output

3. Answers for questions A-F

4. Clearly labeled or highlighted parts of the output that pertain to each answer for ques. A-F.

The Excel assignments are each graded via a short Excel Quiz in HLS Web Test that is open for about 48 hours as listed in the syllabus and in your HLS progress report. You are expected to use your output and written answers to complete the quiz. You are not required to turn in the output.

The questions below are much like the quiz you will have in WEBTEST. If you can answer these, you should have no difficulty with those that will be asked. However, these questions are not the exact questions that you will have to answer.

SAMPLE WEBTEST QUIZ: The correct answers to the sample questions are highlighted.

1. What is the p-value of the test statistic for the global F test for the regression model?

A. 0.444              B. 0.0000                C. 0.9650                   D. 50              E. 2.0696

2. What is the calculated value of the test statistic to conduct the test for the usefulness of the Autodebt variable?

A. 118.98            B. 0.9650                C. 0.234                    D. -1.314         E. 0.0079

3. The best interpretation of R-square for this regression analysis is

60.8 percent of the total variation in a family's expenditure on groceries is explained by regression on the variables X1-X8

77.80 percent of the total variation in a family's expenditure on groceries is explained by regression on the variables X1-X8

57.4 percent of the total variation in a family's expenditure on groceries is explained by regression on the variables X2-X8

72.84 percent of the total variation in a family's expenditure on groceries is explained by regression on the variables X2-X8

95 percent of the total variation in a family's expenditure on groceries is explained by regression on the variables X1-X8

4. The result of the t-test for the usefulness of the Income2 (X2) variable, at a = .05 is to

F.T.R. Ho, since the p-value is greater than .05. Conclude X2 is not useful for predicting Y

F.T.R. Ho, since the p-value is greater than .05. Conclude X2 is useful for predicting Y

Reject Ho, since the p-value is less than .05. Conclude X1 is not useful for predicting Y

F.T.R. Ho, since the p-value is less than .05. Conclude X1 is not useful for predicting Y

Reject Ho, since the p-value is less than .05. Conclude X1 is useful for predicting Y

5. What is the coefficient for Income2 in the sample regression equation?

1. 20.10           B. -1.2504       C. 0.00104      D. 118.97        E. 0.0115                                

Problem 4-18 Interpreting a Report-Weighted-Average Method [LO4-2, LO4-3, LO4-4]

Cooperative San José of southern Sonora state in Mexico makes a unique syrup using cane sugar and local herbs. The syrup is sold in small bottles and is prized as a flavoring for drinks and for use in desserts. The bottles are sold for $12 each. The first stage in the production process is carried out in the Mixing Department, which removes foreign matter from the raw materials and mixes them in the proper proportions in large vats. The company uses the weighted-average method in its process costing system.

A hastily prepared report for the Mixing Department for April appears below:

Management would like some additional information about Cooperative San José’s operations.

Required:

1. What were the Mixing Department's equivalent units of production for materials and conversion for April?

2. What were the Mixing Department's cost per equivalent unit for materials and conversion for April? The beginning inventory consisted of the following costs: materials, $18,920; and conversion cost, $8,712. The costs added during the month consisted of: materials, $84,950; and conversion cost, $41,987.

3. How many of the units transferred out of the Mixing Department in April were started and completed during that month?

4. The manager of the Mixing Department stated, “Materials prices jumped from about $1.95 per unit in March to $2.45 per unit in April, but due to good cost control I was able to hold our materials cost to less than $2.45 per unit for the month.” Should this manager be rewarded for good cost control?

Consider the following snapshot of a system:

Allocation                   Max                 Available

A B C D              A B C D                    A B C D

P0                    0 0 1 2                0 0 1 2                      1 5 2 0

P1                    1 0 0 0                1 7 5 0

P2                    1 3 5 4                2 3 5 6

P3                    0 6 3 2                0 6 5 2

P4                   0 0 1 4               0 6 5 6

Answer the following questions using the banker’s algorithm:

a. What is the content of the matrix Need?

b. Is the system in a safe state? Demonstrate the reason for your answer.

c. If a request from process P1 arrives for (0,4,2,0), can the request be granted immediately? Demonstrate the reason for your answer.

IN TEXT ONLY!!!

Consider the following snapshot of a system: Allocation Max Available A B C D A B C D A B C D

P0 0 0 1 2 0 0 1 2 1 5 2 0

P1 1 0 0 0 1 7 5 0

P2 1 3 5 4 2 3 5 6

P3 0 6 3 2 0 6 5 2

P4 0 0 1 4 0 6 5 6

Answer the following questions using the banker’s algorithm: a. What is the content of the matrix Need? b. Is the system in a safe state? Demonstrate the reason for your answer. c. If a request from process P1 arrives for (0,4,2,0), can the request be granted immediately? Demonstrate the reason for your answer.

(JAVA)

Create a program that creates a mini database of numbers that allows the user to: reset the database, print the database, add a number to the database, find the sum of the elements in the database, or quit.

In main, you will declare an array of 10 integers (this is a requirement). Then you will define the following methods: • printArray (int[ ] arr) – this takes in an array and prints it • initArray (int[ ] arr) – this initializes the array so that each cell is 0 • printSum (int[ ] arr) – this calculates the sum of the elements in the array and prints it • enterNum(int[ ] arr) – this asks the user for a slot number and value – putting the value into the array in the correct slot • printMenu (int[ ] arr) – prints the menu in the sample output (that’s it, nothing more)

In main, create an array of 10 integers and immediately call initArray( ). Then, continuously looping, print the menu and ask the user what they want to do – calling the appropriate methods based on the user’s choice. Note that every time you call a method, you must pass the array that was created in main. If it makes it easier, we used a do-while loop and a switch statement in main.

It should behave like the sample output below: (user input = bold)

Would you like to:

1) Enter a number

2) Print the array

3) Find the sum of the array

4) Reset the array

5) Quit

1

Enter the slot: 5

Enter the new value: 76

Would you like to:

1) Enter a number

2) Print the array

3) Find the sum of the array

4) Reset the array

5) Quit

1

Enter the slot: 2

Enter the new value: 33

Would you like to:

1) Enter a number

2) Print the array

3) Find the sum of the array

4) Reset the array

5) Quit

2

|0|0|33|0|0|76|0|0|0|0

Would you like to:

1) Enter a number

2) Print the array

3) Find the sum of the array

4) Reset the array

5) Quit

3

109

Would you like to:

1) Enter a number

2) Print the array

3) Find the sum of the array

4) Reset the array

5) Quit

4

Would you like to:

1) Enter a number

2) Print the array

3) Find the sum of the array

4) Reset the array

5) Quit

2

|0|0|0|0|0|0|0|0|0|0

Would you like to:

1) Enter a number

2) Print the array

3) Find the sum of the array

4) Reset the array

5) Quit

5

Underline all the correct answers. Explain why an answer is correct or why it is wrong. You are supposed to select all of the correct answers (1-6) for each roman numeral (I-III)

--Please justify/explain answers thoroughly--

Problem 7. If photons with energy of 1.7 eV was applied to A Si Wafer is at 300k (E_g for Si =1.12eV), the valence and conduction band are

(I)

1-      Both are completely empty

2-      Both are completely filled.

3-      Both are partially empty.

4-      Both are partially filled.

5-      None of the above

6-      All of the above 1-4.

(II)

1-      CB band is completely empty and VB is completely filled.

2-      VB band is completely empty and CB is completely filled.

3-      CB band is partially empty and VB is completely filled.

4-      VB band is partially empty and CB is completely filled.

5-      None of the above

6-      All of the above (1-4)

(III)

1-      CB band is partially filled and VB is completely filled.

2-      VB band is partially filled and CB is completely filled.

3-      CB band is partially empty and VB is partially filled.

4-      VB band is partially empty and CB is partially filled.

5-      None of the above

6-      All of the above (1-4)

Barbara has preferences over flowers (x 1) and vases (x 2) represented by u( x 1 , x 2 ) = x 1 x 2. Her income is m=100m = 100 and prices are initially p 1 = 1 and p 2 = 2. If the price of flowers increases to p 1 ′ = 5, the decrease in demand for vases attributed to the income effect is:

1. 0

2. 20

3. 50

4. 75