Run two different multiple regressions using excel. One should include two of the three idepenedent variables and the other should include all three variables. What are the regession equations?

Run two different multiple regressions using excel. One should include two of the three idepenedent variables and the other should include all three variables. The first multiple regression equation is Gross Revenue = 766.981 + 2.977*Daily Tour Income - 12.31*Number of Tourists.

1. What is the second multiple regression equation?  

Would adding dummy variables for the three days for my second regression work? l  need 2 dummy variables since I have 3 categories (days, in this case). What would the equation look like? What's the regression table using excel?

Suppose that we have two bags each containing black and white balls. One bag contains two times as many white balls as black balls. The other bag contains two times as many black balls as white. Suppose we choose one of these bags at random. For this bag we select five balls at random, replacing each ball after it has been selected. The result is that we find all balls are white balls. What is the probability that we were using the bag with mainly black balls?

Assume a two-person, two-good economy. Holding the price of one commodity as numéraire, describe analytically how the price mechanism coordinates the economy. Derive Walras’ law for the two-good economy and discuss its policy implications.

Set up 4 different configurations of charges: two opposite charges, two lines of opposite charges, one cluster of charges and a line of charges, and one configuration of your choice.

For each configuration do the following:

a) Sketch on a separate piece of paper the configuration. Use the whole page.

b) Sketch out at least 10 different equipotential lines by using the voltage probe. (label them)

c) Sketch out at least 10 different electric field lines. (crossing at right angles to the equipotential lines and running from the high to low charge.

d) Mark at 3 places on 3 of the E-field lines the strength of the E-field.

3. One year treasuries yield 5% and two year Treasuries yield 5.50%. You have a two year time horizon. You are considering a one year roll of Treasuries. What would you have to get in the second year to beat just holding the two year Treasury? (Carry your answer out three decimal places.)
4. What are the components of a bond?
5. Assume Capital Inc has an outstanding 15 year bond with a 10% coupon (annual pay) with a par value of $1000. The market yield for this bond is 15%. What is the price/present value of the bond? If the bond is callable in ten years at 102 what would the yield to the call be given the price you calculated above.

The preparatory phase of glycolysis converts one 6-carbon sugar into two 3-carbon sugars and uses two molecules of ATP while the payoff phase of glycolysis converts those two 3-carbon sugars into 2 molecules of pyruvate and generates two molecules of NADH and four molcules of ATP.

True

False

Which of the following best characterizes the termination of transcription?

Which of the following best describes the TATA box?

De novo fatty acid synthesis is primarily regulated by phosphorylation of acetyl-CoA carboxylase, which is stimulated by glucagon and/or epinepherine.

True

False

A certain group of symptom-free women between the ages of 40 and 50 are randomly selected to participate in mammography screening. The incidence rate of breast cancer among such women is 0.8%. The false negative rate for the mammogram is 10%. The false positive rate is 7%. If a the mammogram results for a particular woman are positive (indicating that she has breast cancer), what is the probability that she actually has breast cancer?

You work for a supermarket that is considering the best way to promote sales of its store-brand canned vegetables. Store managers believe allocating additional shelf space to the store-brand canned vegetables would create additional sales. Company executives, on the other hand, believe increasing advertising expenditures would be a more effective strategy to expand sales. Complete a regression analysis to help answer this question (use the CANVEG Excel file posted on Canvas). NOTE: consider only a simple linear model, a multiple linear regression model, or an interaction model

1.Write out the equation that represents the hypothesized population regression equation for your model

2.Explain whether a positive or negative relationship is hypothesized

3.Use the “Microsoft Excel Data Analysis Toolpak” to determine the regression coefficients for the relationship and write out the final estimated regression equation. You must include the MS Excel output.

4.Give a practical interpretation of the slope(s) of the least squares line

5.Over what range of x-values is the interpretation meaningful?

6.Does the estimated slope support the relationship between the two variables you initially hypothesized (in parts a and b)? Explain.

7.Evaluate the overall utility of the model including any relevant hypothesis tests (be sure to fully write all 6-steps of any hypothesis test conducted, you can specify the rejection region in words it is not necessary to include a graph though you can if you prefer to).

8.Include any hypothesis tests of individual coefficients that are appropriate given your choice of model specification and results.

9.Given your results, would you recommend the company pursue expanding shelf space or increase advertising expenditures.

Two pea plants are crossed. One is homozygous for white flowers and the other is heterozygous for purple flowers. Both are heterozygous for being tall plants. In pea plants, tall is dominant to short, and purple flowers are dominant to white.

Fill out the table below for the probability of each possible phenotype. Report probability as a decimal rounded to four places (e.g. 0.1250, not 1/8 or 12.5%).

In a population of 150 pea plants, there are 50 tall-purple plants, 18 short-purple plants, 62 tall-white plants, and 20 short-white plants. In order to test if the two traits are experiencing independent assortment researchers would perform a chi squared test. The (null/alternative) ____________ hypothesis states that the two genes are independently assorted while the (null/alternative) ___________ hypothesis states the two genes are dependent.

What is your calculated Chi Squared statistic? ____________

When performing a contingency table, do not round your expected values!!

Report your calculated X² rounded to four decimal places

What is the corresponding P value? ____________

Use the formula =1-(CHISQ.DIST(X²,df,TRUE)) to convert calculated X^{2 _{into a P value}}

Report your answer rounded to 4 decimal places

Do you fail to reject or reject the null hypothesis? __________

As a result of this statistical analysis, it is possible to conclude that pea plant height and pea plant blossom color (are or are not) ___________ linked traits.