Week 8 1. (TCO 5) Answer the following questions using the New Customer Data lin

Question

Week 8 1. (TCO 5) Answer the following questions using the New Customer Data linear regression output table below. a. What is the equation of the line of best fit for this problem? b. How strong is the relationship between the Period number and New Customers? Why did you reach that conclusion? c. Is this model statistically significant? Why? d. Make a prediction for period 17 using the data. Please show your work. New Customer Data Linear Regression Output Table Period New Customers 1 32 Summary Output 2 26 3 32 Regression Statistics 4 38 Multiple R 0.954508465 5 42 R Square 0.911086409 6 37 Adjusted R Square 0.904735438 7 40 Standard Error 4.032131971 8 39 Observations 16 9 52 10 58 Anova 11 55 df SS MS F Significance F 12 60 Regression 1 2332.324265 2332.324265 143.4562435 9.58318E-09 13 59 Residual 14 227.6132353 16.25808824 14 58 Total 15 2559.9375 15 62 16 69 Coefficients Standard Error tStat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 25.175 2.114467844 11.90606897 1.03454E-08 20.63991753 29.71008247 20.63991753 29.71008247 X Variable 1 2.619117647 0.218673059 11.97732205 9.58318E-09 2.150110583 3.088124711 2.150110583 3.088124711 (Points : 25) 2. (TCO 7) Describe how a data warehouse's design is optimized for report generation and decision-making. a) Indicate the two types of data warehouse designs, indicating the difference in their complexity and structure. b) Describe two reasons why the design of a data warehouse is better than the design of an operational database, given the purpose of the data warehouse. (Points : 25) 3. (TCO 8) Review the following Program Data table and answer the questions that follow (a & b). Program Data Table Program Number of Students BIS 500 CIS 100 EET 150 NetCom 400 HIT 150 Web & Graphics 100 a. Which of the data visualization techniques we've studied in this course would you use to present this data descriptively and graphically to a decision maker? b. Give a reason for why you chose this way of presenting the data in part (a). Review the following GDP and Company Sales by Quarter Table and answer the questions that follow (c & d). GDP and Company Sales by Quarter Table Quarter Gross Domestic Product Growth Company Sales 1 0.05 100 2 0.04 110 3 0.03 90 4 0.05 110 6 0.045 110 7 0.03 75 8 0.025 65 c. Which of the data visualization techniques we've studied in this course would you use to present this data descriptively and graphically to a decision maker? d. Give a reason for why you chose this way of presenting the data in part (c). (Points : 25) Page: 1 2 3 4

Explanation / Answer

For 60 sec we can expect 60/50 s to process 1 request

=>for 40 s we have 60/50 * 40 s busy time

=> 60 - 60*40/50 idle time

=>60-48 = 12s

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.