Business Statistics Assignment

At 5% level of significance, is there sufficient evidence to conclude that the proportions of errors in transactions assigned to each of the 5 memory locations are all different?

Exercises 12.17, 12.21, and 12.43 require the use of the “Regression” function within the Data Analysis menu in Excel. Refer to Appendix E12 for instructions on using Excel for these exercises.

The formula refers to a cell range that Excel cannot understand. Make sure that the range is entered correctly.

Question 9.9. (TCO 2) To copy a formula, you may use the _____, which is found in the bottom right-hand corner of an active cell. (Points : 2)

Provide formulas in cells M2 through M8 that square the differences found in cells L2

4. The calculation should be executed only after all the valid input values are provided.

Explain the corresponding impact on total revenue for each of the three price ranges identified in part G.

Multiply line 22, column (b) by line 7 . . . . . . . . . . .

To fix the error: The cell DI7 should be left blank or it must contain a number. What should we with those cells?

29. A distribution center for a chain of electronics supply stores fills and ships orders to retail outlets. A random sample of orders is selected as they are received and the dollar amount of the order (in thousands of dollars) is recorded, and then the time (in hours) required to fill the order and have it ready for shipping is determined. A scatterplot showing the times as the response variable and the dollar amounts (in thousands of dollars) as the predictor shows a linear trend. The least squares regression line is determined to be: yˆ= 0.76 +1.8x. A plot of the residuals versus the dollar amounts showed no pattern, and the following values were reported: Correlation r +0.90; R 2 = 0.81; standard deviation of the residuals is 0.48. What percentage of the variation in the times required to prepare an order for shipping is accounted for by the fitted line?

Project two in ECON-E 281 - APPLIED STAT FOR BUS & ECON II consisted of the students evaluating three independent variables such as Pickup Time, Delivery Time, and Mileage. The dependent variable was Cost. Only one independent variable could be selected when applying “ONLY” the p-value approach. The first step, I selected the Data then the Data Analysis tool. Next select Regression. The Input Y Range I selected the Cost data. The Input X range I selected the first independent variable Pickup time. Then check marked the boxes Labels, Confidence Level 95%, New Worksheet Ply, Residuals, and Residuals Plots. After checking the boxes I pressed OK. This gave me my first regression model. I used this process for the next two independent variables

Using MINITAB perform the regression and correlation analysis for the data on SALES (Y) and CALLS (X), by answering the following questions:

error in the prediction using this regression equation may be high, and I would consider this

3. Refer to the monthly sales forecasts given in the first Table. Assume that these amounts are realized and that the firm’s customers pay exactly as predicted.

Calculations to estimate the following years 5 and 6 are done in the excel tab called ‘Estimation Years 5 and 6’. Taking into account that the predicted remaining