Expedia wants to use regression analysis to build a model for airfare tickets prices in the states: Ticket prices = 30 + 31 Miles + E where Miles is measured in hundreds Coefficients 169.50 5.90 Intercept Miles (in hundreds) Which of the following is true? Standard Error 1.34 0.09 t Stat 126.85 61.28 P-value 0.000 0.002 O If Miles increases by 1, then we predict ticket price to go up by $5.9. O If ticket price goes up by $1, then we predict Miles to go up by 590 miles. O If ticket price goes up by $100, then we predict Miles to go up by 590 miles. If Miles increases by 100, then we predict ticket price to go up by $5.9.

Please provide the correct answer along with the calculation. Do not use ChatGPT, otherwise I will give a downvote.

"In the regression model InY=b0+b1*InX+u, the coefficient b1 is interpreted as" O the intercept O A covariance O A regressor O An elasticity

An analyst working for your firm provided an estimated log-linear demand function based on the natural logarithm of the quantity sold, price, and the average income of consumers. Results are summarized in the following table: SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Regression Residual Total Intercept LN Price LN Income df 0.968 0.937 0.933 0.003 30 SS MS F 2 0.003637484 0.001818742 202.48598 0.000242516 8.98206E-06 27 29 0.00388 Coefficients Standard Error 0.57 0.00 0.13 0.51 -0.08 0.15 t Stat 0.90 -19.50 1.13 P-value 0.37 0.00 0.27 Significance F 5.55598E-17 Lower 95% -0.65 -0.09 -0.12 How would a 4 percent increase in income impact the demand for your product? Demand would increase by 60 percent. Demand would increase by 0.6 percent. Demand would decrease by 60 percent. Demand would decrease by 0.6 percent. Upper 95% 1.68 -0.07 0.41

6) Suppose you have the following data on the price of orange and the quantity sold: Price per Pound (in Quantity Sold (in Dollars) Pounds) 0.50 0.75 1.00 1.25 1.50 10 7 699 5 2 Assume that the quantity sold (Y) is a linear function of the price (X), i.e. Y₁ =B₁ + B₂X₁ + ε₁ Estimate the population regression coefficients. (Do not use Computer)

The data for this question is given in the file 1.Q1.xlsx(see image)  and it refers to data for some cities X1 = total overall reported crime rate per 1 million residents X3 = annual police funding in $/resident X7 = % of people 25 years+ with at least 4 years of college   (a) Estimate a regression with X1 as the dependent variable and X3 and X7 as the independent variables. (b) Will additional education help to reduce total overall crime (lead to a statistically significant reduction in crime)? Please explain. (c) Will an increase in funding for the police departments help reduce total overall crime (lead to a statistically significant reduction in total overall crime)? Please explain. (d) If you were asked to recommend a policy to reduce crime, then, based only on the above regression results, would you choose to invest in education (local schools) or in additional funding for the police? Please explain.

E3

Please don't provide hand written solution

Q4. The Omantel firm has estimate the Sales of fibre internet connections in Oman with the related to advertising expenditure made by the company over the past 26 months. Following is the firm estimated results of the regression equation. DEPENDENT VARIABLE: Y R-SQUARE F-RATIO P-VALUE ON F OBSERVATIONS: 26 0.85121212 8.747 0.0187 PARAMETER STANDARD VARIABLE ESTIMATE ERROR T-RATIO P-VALUE INTERCEPT 7.6 6.33232 1.200 0.2643969 3.53 0.52228 ? 0.0001428 a. What is the dependent and independent variables in the above regression equation of Omantel firm? b. Calculate the estimated t-ratio. Test the slope estimates for statistical significance at the 10 percent significance level. d. Interpret the coefficient of determination.

General Cereals is using a regression model to estimate the demand for Tweetie Sweeties, a whistle-shaped, sugar-coated breakfast cereal for children. The following (multiplicative exponential) demand function is being used: QD = 6,280 P(-2.15) A1.75N2.70 where QD = quantity demanded, in 10-oz boxes P = price per box, in dollars A = advertising expenditures on daytime television, in dollars N = proportion of the population under 12 years old, in percent What is the point price elasticity of demand for Tweetie Sweeties? 1.75 -1.23 2.70 -2.15 What is the advertising elasticity of demand? 0.65 1.75 -2.15 2.70 According to the estimated model, a percent increase in the proportion of the population under 12 years old by percent. the quantity demanded