The following Regression function has been developed to check the relationship between Y- ‘Sales’ and the following independent variables;
X1- Time (Length of time employed in months)
X2 –Poten (Market potential)
X3 – AdvExp (Advertising expenditure in the sales territory)
X4 – Accounts (Number of accounts assigned to sales rep)
3 Consider the following Minitab output and answer the questions. Regression Analysis: Sales versus Time, Poten, AdvExp,
Accounts Regression Equation Sales = -391 - 0.58 Time + 0.02227 Poten + 0.2178 AdvExp + 16.31
Accounts Coefficients Term Coef SE Coef T-Value P-Value VIF Constant -391 470 -0.83 0.415 Time -0.58 2.20 -0.26 0.794 2.46
Poten 0.02227 0.00895 2.49 0.022 1.34
AdvExp 0.2178 0.0468 4.65 0.000 1.07
Accounts 16.31 4.20 3.88 0.001 2.48
Model Summary S R-sq R-sq(adj) R-sq(pred) 595.985 82.83% 79.40% 72.74%
Analysis of Variance Source DF Adj SS Adj MS F-Value P-Value Regression 4 34275579 8568895 24.12 0.000
Time 1 24781 24781 0.07 0.794
Poten 1 2198350 2198350 6.19 0.022
AdvExp 1 7683578 7683578 21.63 0.000
Accounts 1 5346156 5346156 15.05 0.001
Error 20 7103970 355198 Total 24 41379549
e. 4 pts. What can you say about “goodness of fit” for the above regression model fit based on the appropriate value from the output?
f. 4 pts. Is normality assumption about the error ? satisfied based on the above Minitab output? Explain.
g. 4 pts. Is constant variance assumption about the error ? satisfied based on the above Minitab output? Explain.
h. 6pts. Why do we use R-sq(adj) in multiple linear regression rather than R_sq? Make sure to explain in detail.
In: Statistics and Probability
Question 4 Suppose a study reports that the average price for a gallon of self-serve regular unleaded gasoline is $3.16. You believe that the figure is higher in your area of the country. You decide to test this claim for your area of the United States by randomly calling gasoline stations. Your random survey of 25 stations produces the following prices (all in dollars). Assume gasoline prices for a region are normally distributed. Did the data you obtained provide enough evidence to reject the claim? Use a 1% level of significance. Make sure you clearly state both the null and the alternative hypotheses in full sentences. Following your calculations, clearly state the conclusion in the same manner (do not simply say “accept/reject null”) and explain how you arrived at this conclusion (based on which metrics). 3.27 3.3 3.16 3.15 3.11 3.05 3.54 3.25 3.05 3.11 3.13 3.15 3.27 3.14 3.14 3.2 3.3 3.09 3.05 3.07 3.37 3.34 3.35 3.35 3.1 GB513: Business Analytics 3 of 5 Question 5 Where do CFOs get their money news? According to Robert Half International, 47% get their money news from newspapers, 15% get it from communication/colleagues, 12% get it from television, 11% from the Internet, 9% from magazines, 5% from radio, and 1% do not know. Suppose a researcher wants to test these results. She randomly samples 76 CFOs and finds that 40 of them get their money news from newspapers. Does the test show enough evidence to reject the findings of Robert Half International? Use a = .05. Make sure you clearly state both the null and the alternative hypotheses in full sentences. Following your calculations, clearly state the conclusion in the same manner (do not simply say “accept/reject null”) and explain how you arrived at this conclusion (based on which metrics). Question 6 To answer this question, use the Data Analysis Toolpack in Excel and select “t-Test: Two-Sample Assuming Equal Variances” from the list of available tools. Conduct a hypothesis test using this tool. Explain your answer (how you decided if men spend more or not) and include the output table. Some studies have shown that in the United States, men spend more than women buying gifts and cards on Valentine’s Day. Suppose a researcher wants to test this hypothesis by randomly sampling men and women with comparable demographic characteristics from various large cities across the United States to be in a study. Each study participant is asked to keep a log beginning 1 month before Valentine’s Day and record all purchases made for Valentine’s Day during that 1-month period. The resulting data are shown below. Use these data and a 1% level of significance to test to determine if, on average, men actually do spend significantly more than women on Valentine’s Day. Assume that such spending is normally distributed in the population and that the population variances are equal. Make sure you clearly state both the null and the alternative hypotheses in full sentences. Include the output table; then, clearly state the conclusion in the same manner (do not simply say “accept/reject null”) and explain how you arrived at this conclusion (based on which metrics). Men Women 107.48 125.98 143.61 59.32 90.19 96.35 125.53 80.62 70.79 77.6 83 84.34 129.63 75.21 154.22 68.48 GB513: Business Analytics 4 of 5 93.8 65.84 111.25 126.11 78.6 82.54 89.35 123.5
In: Statistics and Probability
As a newly appointed project manager, you are about to commence a cutting edge I.T. project within your organisation. It is the first time your organisation has undertaken a project like this in-house.
How do you decide whether to use a predictive or adaptive approach?
Briefly explain some of the characteristics common across all project life cycles.
Which project lifecycle do you choose and why?
In: Computer Science
When a bond sells at a premium, is the periodic interest expense less than, equal to, or greater than the periodic interest payment? Why? Be specific. State any accounting principles that must be invoked, and how that (those) principle(s) apply. What is the role of the premium account in your answer? Fully explain why as we practiced in class. Be concise, yet thorough in your explanation.
In: Accounting
*** THIS IS FOR BA:498 STRATEGIC MANAGEMNT*** NEED THIS BY TOMORROW!!!
(1) Examine the top corporate brands as presented by Interbrand (www.interbrand.com (Links to an external site.)Links to an external site.). Select one company from the list and outline a core competency that you believe that they have. Try to select a company/brand that has not already been covered by one of your classmates. Why do you believe this is a powerful competency for this company?
(2) Refer back to this weeks “readings, articles, videos” section and the discussion of corporate values and Nordstrom. How do you think the Nordstrom snow tire story would influence company culture? Please share one example from your own experience of a story or artifact that influenced culture where you worked or attended school.
**** this is the link to the Nordstorm story*** https://www.youtube.com/watch?v=NTqBhdUnisl
(3) Refer back to this weeks “readings, articles, videos” section and the discussion of finance and accounting and Apple. Please look over the financial statements referred to in the lecture notes. What conclusions can draw about Apple and the evolution of their business during this timeframe? Do you believe the same dynamics exist today? How would you determine that
In: Operations Management
Suppose, in a nation called Utopian (which happens to calculate unemployment rates the same way the United States does), the number of discouraged workers is 10 million people; the number of full time students is 60 million people; the number of stay at home spouses is 200 million people; the number of underemployed workers is 40 million people; the number of phantom unemployed persons is 25 million people; the number of officially classified employed persons equals 300 million people; number of officially classified unemployed persons equals 40 million people; and the civilian non-institutionalized population equals 600 million people.
(a) Based on this information, calculate the official unemployment rate to the second decimal place (hundredths place). Please show how you got your answer – meaning show your work. Remember to state your answer as a percent (including the percent symbol, since without the percent symbol, your answer becomes meaningless).
(b) In one factual sentence (without any opinion of whether you think your answer is high or low), please clearly explain what information your answer in (a) above tells us.
In other words, the unemployment rate you calculated in (a) above tells us what information?
Make sure to use your answer in (a) in your sentence here.
(c) Now if the number of discouraged workers were reclassified as officially unemployed persons, how would this change the reported unemployment rate?
Again make sure that your unemployment rate number is reported to the second decimal place (hundredths place). Again, please show your work and present your answer as a percent.
(d) Based on your answers for (a) and (c) above, would you say that by the Bureau of Labor Statistics not counting discouraged workers as unemployed persons, that the reported unemployment rate tends to underestimate or overestimate the unemployment situation in the country? In your explanation, you must support your answer with your numbers from your answers for (a) and (c) above.
(e) Please explain who discouraged workers represent and what is it about discouraged workers that has the reported unemployment rate either underestimating or overestimating the unemployment situation in the country.
In: Economics
Group 3:
In: Nursing
In: Economics
In: Biology
can you use a simple magnifier on the image created by another simple magnifier? Why/why not? What must be true about an image for you to use your simple magnifier on it?
In: Physics