Global Bikes Inc. (a bicylce manufacturing firm) collected the following data during a study of consumer buying patterns. Observation x y Observation 1 15 70 2 3 28 79 38 35 49 42 30 89 86 97 97 82 9 10 11 0.721 12 13 a. Create a linear regression line (equation) for the data.(Round your Intermediate calculations and final answers to 3 decimal places.) x y 14 82 16 70 14 68 24 84 21 83 29 91 63.229 X b. Use the equation determined in part b to predict the expected value of y for x = 49. (Round your Intermediate calculations and final answers to 3 decimal places.)

snip

Tucson Machinery, Inc., manufactures numerically controlled machines, which sell for an average price of $14.0 million each. Sales for these NCMs for the past two years were as follows: Use Exhibit 3.10. QUARTER LAST YEAR I II III IV QUANTITY (UNITS) Y = 14 20 28 18 QUARTER THIS YEAR I II III IV QUANTITY (UNITS) 20 26 30 15 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.) > Answer is complete but not entirely correct. 18.535 X + 0.630 t

Data on 10 mid-level managers in insurance industry is given below, in the box. Employees refer to number of employees supervised and salary refer to annual salary in 1000$.Employees 28 31 38 38 43 47 48 49 53 56Salary 99 102 136 127 157 121 173 197 200 176a. Create the regression equation.b. Forecast the salary of a manager who supervises 90 employees by using the regression equation you created.

25. Consider the following time series data: Quarter 1 234 Year 1 4 4235 2 5 Year 2 6357 5 7 Year 3 7 6 6 8 a. Construct a time series plot. What type of pattern exists in the data? b. Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. c. Compute the quarterly forecasts for next year.

Please help with correct answers: step by step: last time submitted- answers were incorrect A statistical program is recommended. The quarterly sales data (number of copies sold) for a college textbook over the past three years follow. Quarter Year 1 Year 2 Year 3 1 1,690 1,800 1,850 2 940 900 1,100 3 2,625 2,900 2,930 4 2,500 2,360 2,615 a) Use a regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. (Round your numerical values to the nearest integer.) Qrt1 = 1 if quarter 1, 0 otherwise; Qrt2 = 1 if quarter 2, 0 otherwise; Qrt3 = 1 if quarter 3, 0 otherwise t =    b) Using the equation developed in part (b), compute the quarterly forecasts for year 4. (Round your answers to the nearest ten.) quarter 1 forecast____? quarter 2 forecast____? quarter 3 forecast ____? quarter 4 forecast ____?   c) Let t = 1 refer to the observation in Quarter 1 of Year 1; let  t = 2 refer to the observation in Quarter 2 of Year…

Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the past 12 months were as follows:                                                                                                                a) Use a 2-month moving average on all the data and plot the averages and the prices.b) Use a 3-month moving average a nd add the 3-month plot to the graph created in part (a).c) Which is better (using the mean absolute deviation): the 2-month average or the 3-month average?d) Compute the forecasts for each month using exponential smoothing, with an initial forecast for January of $1.80. Use a = .I, then a = .3, and finally a = .5. Using MAD, whicha is the best?

Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6 7 2 2 3 6 3 3 5 6 4 5 7 8 a. Construct a time series plot. What type of pattern exists in the data? Trend Pattern Seasonal Pattern Horizontal Pattern O Trend and Seasonal Pattern Question 11 5 pts b. Create the following dummy variables: Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. Create a variable t such that t = 1 for quarter 1 of year 1, t = 2 for quarter 2 of year 1, ..., t = 12 for quarter 4 of year 3. Use these dummy variables and t to develop an estimated regression equation to account for seasonal effects and any linear trend in the data. What is the forecast for quarter 1 of next year?

1- A pharmacist has been monitoring sales of certain over-the-counter pain reliever. Daily sales during the last 15 days were as follows: Day 1 2 3 4 7 8 9 Number sold 36 38 42 44 48 49 50 49 52 Day 10 11 12 13 14 15 Number sold 48 52 55 54 56 57 a: By using linear regression method predict the future sales for the next 5 days (please do all calculations in excel and send the excel file with answers included as your response) b: calculate the MSE for the prediction of these 15 days. (again by using Excel) 1- Explain how QFD can be employed for designing a new restaurant in your region in Iraq? (at least 100 words) 2- A producer of inkjet printers is planning to add a new production line of printers, and you have been asked to balance the process, given the following task times and precedence relationships. Assume the cycle time is to be minimum possible (based on the bottleneck). Immediate Length (minutes) Task (Predecessor) a 0.2 b 0.4 a 0.3 d 1.3 b, c e 0.1 f 0.8 e g 0.3 d, f 1.2 g a…

data table below shows the number of computers sold at the Best Buy Store in a week, based on online ads.   Online Ad               Computers Sold   2                               25        1                               10 4                               30 1                               10 2                              25 sigma)x=10                        sigma)y=100 draw the graph of the regression equation, showing the slope and y intercepts?