AAA Inc sells metal sports bottles. The bottles sell for $3.00. Regression for the number of...
1st regression analysis
2nd regression analysis
1. Analyze the two regression analysis's above and make
a recommendation on if the organization should increase, decrease,
or retain their pricing and why?
2. What happens to the dependent variable Y if the price
X1 decreases in the second regression analysis?
SUMMARY OUTPUT Y=UNITS SOLD X=PRICE Regression Statistics Multiple R R Square Adiusted R S Standard Error Observations 0.874493978 0.764739718 0.756026374 159.2178137 29 quare ANOVA df MS Significance F 1 2224908.261 2224908.26187.76650338 5.64792E-10...
Calculate the following statistics given the existing information (1 point per calculation): Regression Statistics Multiple R R Square Adjusted R Square 0.559058 Standard Error Observations 30 ANOVA df SS MS F Significance F Regression 2 3609132796 19.38411515 6.02827E-06 Residual 27 2513568062 Total 29 6122700857 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept -15800.8 57294.51554 -0.27578 0.784814722 CARAT 12266.83 1999.250369 6.135715 1.48071E-06 DEPTH 156.686 928.9461882 0.168671 0.867312915 Additionally interpret your results. Be sure to comment on Accuracy, significance...
In a yearlong study of gas usage to heat a particular building, on 37 randomly selected days during the year, the average outside temperature was measured as well as the corresponding gas usage for a 24-hour period. The simple linear model E(y) = β0 + β1x, where x is the average outside temperature over a 24-hour period and y is the gas usage during that same time period, was fit to the data. The analysis is given below.Regression StatisticsMultiplier0.4804958R Square0.23087621Adj...
Regression Statistics Multiple R 0.896755 R Square 0.80417 Adjusted R Square 0.767452 Standard Error 51.04855 Observations 20 ANOVA df SS MS F Significance F Regression 3 171220.5 57073.49 21.90118 6.56E-06 Residual 16 41695.28 2605.955 Total 19 212915.8 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 427.1938 59.60143 7.167509 2.24E-06 300.8444 553.5432 300.8444 553.5432 Temp (deg) -4.58266 0.772319 -5.93364 2.1E-05 -6.21991 -2.94542 -6.21991 -2.94542 Insulation (ins.) -14.8309 4.754412 -3.11939 0.006606 -24.9098 -4.75196 -24.9098 -4.75196...
Determine whether the High-Low method or Regression Analysis is
better to predict monthly overhead costs. Explain which model is
the better? Why or why not?
Use absolute cell address in y = a + bX
formula (Use absolute August X Value) to predict January and
December overhead costs. Do you think these predicted overhead
costs are reasonable?
Observation Month Known X Known Y Overhead Cost Production Units $250,000.00 34000 $184,000.00 26000 $165,000.00 21000 $178,000.00 24000 $192,000.00 28000 $225,000.00 32000 $210,000.00...
Multiple Regression Analysis This information is taken from 80 homes recently sold along the Gulf of Mexico coast.Analyze the data to discover which of the variable have a statistically significant influence on the sales price. A. Write out the equation for the model you develop B, Interpret the equation as a model and the meaning of the information for each variable in your "best" model C.Interpret the confidence intervals for each of the statistically significant variables Use the data provided...
Regression Statistics Multiple R xxxxxxx R Square XXXXXXX Adjusted R Square xxxxxxx Standard Error xxxxxxx Observations 187 ANOVA SS MS E xxxxxxx Significance F xxxxxxx XXXXXXX Regression Residual 8 14869.61 178 xxxxxxx 1864040 60 Total Intercept hmwk att att2 hwmk att Coefficients Standard Error Stat P-value Lower 95% Upper 95% -216.24 249.7507872 -0.8658255 0.387751 -709.09 276.61 0.207 XXXXXXX XXXXXXX 0.01894XXXXXXX XXXXXXX -.0336 0.158 XXXXXXX XXXXXXX XXXXXXX XXXXXXX 0.00124 xxxxxxx XXXXXXX 0.34512 xxxxxxx XXXXXXX 0.0026 0.0105 xxxxxxx xxxxxxx | XXXXXXX XXXXXXX...
MULTINATIONAL FIRMS & DEMAND DIFFERENCES A multinational firm sells its products both in the U.S. and overseas. Recently, the ownership of this firm became concerned regarding the potential existence of significant differences in the demand for the firm's products between its U.S. and foreign markets. The firm's owners decided to hire a business statistician to determine whether or not their fears were valid. The business statistician collected the following data from 10 of the multinational firm's markets: 1. Unit Sales:...
Regression Analysis
Find a model from the 26 predictor variables using any model
selection procedure you like to predict GIFTAMNT. GIFTAMNT is the
amount of money donated by the donor in the last solicitation.
Also build a prediction model to predict NGIFTALL which helps us
answer the question, that what leads people to gift more
frequently? You must include NUMPRM12 and NUMPROM in this model to
see on average how many times a donor needs to be contacted to
generate...
The Heartlake Corporation manufactures and sells toy gyroscopes. The following data is related to sales and production of the toy gyroscopes for last year. Selling price per unit Variable manufacturing costs per unit Variable selling and administrative expenses per unit Fixed manufacturing overhead (in total) Fixed selling and administrative expenses in total) Units produced during the year Units sold during year $8.10 $1.86 $4.95 $77,000 $85,000 520,000 170,000 Using variable costing, what is the contribution margin for last year? O...