1. Crop yields per acre depend on many variables, but two obvious ones are fertilizer and weed control. In an effort to test the effects of various levels of fertilizer and of herbicide, researchers selected six plots of land and subdivided each into eight pieces. Each of the eight pieces of each plot was treated with one of the eight combinations of fertilizer (none, light, moderate, heavy) and herbicide (none, some). The per acre yields of each piece of land are recorded below:

In the data, levels of fertilizer are 1 (none), 2 (light), 3 (moderate), 4 (heavy) and levels of herbicide are 1 (none) and 2(some).

fert     herb   yield

1        1        64.40

1        1        61.20

1        1        58.34

1        1        59.72

1        1        62.84

1        1        62.59

2        1        59.09

2        1        62.59

2        1        63.71

2        1        64.01

2        1        66.50

2        1        60.11

3        1        64.40

3        1        66.98

3        1        63.78

3        1        66.52

3        1        65.17

3        1        62.33

4        1        54.69

4        1        64.27

4        1        64.40

4        1        63.56

4        1        65.77

4        1        66.07

1        2        57.50

1        2        59.38

1        2        61.04

1        2        61.54

1        2        61.06

1        2        61.64

2        2        66.67

2        2        63.62

2        2        66.20

2        2        65.59

2        2        62.85

2        2        66.07

3        2        70.37

3        2        62.72

3        2        67.85

3        2        63.74

3        2        64.88

3        2        63.96

4        2        61.83

4        2        64.20

4        2        65.94

4        2        67.56

4        2        60.28

4        2        67.75

Give a statement to be tested, identify the random variables involved and the assumptions you make about them, state the hypotheses to be tested, ask SPSS to run the analysis for you, including a post hoc, and then discuss the outcome. Describe the critical region(s) upon which you base your decisions. Include any SPSS output in your discussion.

1. Crop yields per acre depend on many variables, but two obvious ones are fertilizer and weed control. In an effort to test the effects of various levels of fertilizer and of herbicide, researchers selected six plots of land and subdivided each into eight pieces. Each of the eight pieces of each plot was treated with one of the eight combinations of fertilizer (none, light, moderate, heavy) and herbicide (none, some). The per acre yields of each piece of land are recorded below:

In the data, levels of fertilizer are 1 (none), 2 (light), 3 (moderate), 4 (heavy) and levels of herbicide are 1 (none) and 2(some).

fert     herb   yield

1        1        64.40

1        1        61.20

1        1        58.34

1        1        59.72

1        1        62.84

1        1        62.59

2        1        59.09

2        1        62.59

2        1        63.71

2        1        64.01

2        1        66.50

2        1        60.11

3        1        64.40

3        1        66.98

3        1        63.78

3        1        66.52

3        1        65.17

3        1        62.33

4        1        54.69

4        1        64.27

4        1        64.40

4        1        63.56

4        1        65.77

4        1        66.07

1        2        57.50

1        2        59.38

1        2        61.04

1        2        61.54

1        2        61.06

1        2        61.64

2        2        66.67

2        2        63.62

2        2        66.20

2        2        65.59

2        2        62.85

2        2        66.07

3        2        70.37

3        2        62.72

3        2        67.85

3        2        63.74

3        2        64.88

3        2        63.96

4        2        61.83

4        2        64.20

4        2        65.94

4        2        67.56

4        2        60.28

4        2        67.75

Give a statement to be tested, identify the random variables involved and the assumptions you make about them, state the hypotheses to be tested, ask SPSS to run the analysis for you, including a post hoc, and then discuss the outcome. Describe the critical region(s) upon which you base your decisions. Include any SPSS output in your discussion.

Create a Graph and label axis - These data come from the 2008 General Social Survey. A subset of 190 respondents were selected at random from the full data set. Graph either: 1. a. Histograms b. Bar charts c. Box plots d. Stem-and-leaf plots e. Pie charts f. Line charts g. Frequency tables Variable Information: HEALTH: 1 = Poor, 2 = Fair, 3 = Good, 4 = Excellent. Health 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4

1) What is the variance of scores of 0, 1, 1, 2?

2) If a raw score is 28, M = 20, and SD = 2. The Z score is ?

3) What Z score would a person need to be in the top 5% of his or her class on a particular test? (Assume a normal distribution.)

please help

2. Clean Chips is a manufacturer of prototype chips based in Dublin, Ireland. Next year, in 2019, Clean Chips expects to deliver 700 prototype chips at an average price of $52,000. The plant cannot produce these prototype chips annually in the plant’s current condition. To meet future demand, Clean Chips must either modernize the plant or replace it. The old equipment is fully depreciated and can be sold for $4,450,000 if the plant is replaced. If the plant is modernized, the costs to modernize it are to be capitalized and depreciated over the useful life of the updated plant. The old equipment is retained as part of the modernize alternative. The following data on the two options are available: Modernize Replace Initial Investment in 2019 $ 36,800,000 $ 61,700,000 Terminal Disposal Value in 2025 $ 7,000,000 $ 17,000,000 Useful Life 7 Years 7 Years Total annual cash variable costs per chip $ 35,500 $ 26,000 Clean Chips uses straight-line depreciation, assuming zero terminal disposal value. For simplicity, we assume no change in prices or costs in future years. The investment will be made at the beginning of 2019, and all transactions thereafter occur on the last day of the year. Clean Chips’ required rate of return is 10%. Clean Chips has a special waiver on income taxes until 2026. Required:

1. Calculate net present value of the modernize and replace alternatives.

2. Which alternative should Clean Chips choose?

3. What factors should Clean Chips consider in choosing between the alternatives?

I need it done in excel without making a cash flow chart as well as the formulas needed to get the NPV. or what was plugged into the PV formula

With these time series:

Using time series decomposition, present a seasonally adjusted series for your assigned data (assume the multiplicative model).

With these time series:

Present a line graph for the time series. Describe the time series in terms of the observable components (trend and seasonality).

Deseasonalize the data and use an appropriate technique to find the seasonally unadjusted forecasts for the next year. Include your results here, showing the deseasonalized data and the seasonally unadjusted forecasts.

SHOW ALL STEPS and ANSWER ALL SECTIONS. Using the spreadsheet above and import it into Minitab to answer the following:

1. Fit a binary logistic model to the data and report your results

a. What are the odds of a consumer who viewed the advertisement buying the cereal compared to a consumer who did not view the advertisement?

b. What are the odds of a consumer who has children buying the cereal compared to a consumer who does not have children?

c. Does the model fit the data well? Explain.

d. Is there evidence that the model does not fit the data well? Explain.

We know that 1 + 2 + 3 = 1 · 2 · 3, that is, there exist three positive integers whose sum equals their product.

Prove or disprove: There exist twenty positive integers (not necessarily distinct) whose sum equals their product.