See the attached file. Suppose that the sales manager of a large automotive parts distributor wants to estimate as early as April the total annual sales of a region. On the basis of regional sales, the total sales for the company can also be estimated. If, based on past experience, it is found that the April estimates of annu
See attached file. The given describes data for each state of the 50 states. -Total expenditures on a state's criminal justice system (in thousand of dollars)(EXPEND) -Total number of police employed in the state (POLICE) -Population of the state (in thousand) (POP) total number of incarcerated prisoners in the state (PRI
Problem Data Service Time Data x y Calls Copiers Minutes 1 4 109 2 2 58 3 5 138 4 7 189 5 1 37 6 3 82 7 4 103 8 5 134 9 2 68 10 4 112 11 6 154 I need: Estimate unknown model parameters The Least Squares Point Estimates
Problem 1 - The following table gives the median weekly earnings of full-time wage and salary workers 25 years and older who have had one to three years of college ... Problem 2 - Refer to the Baseball 2002 data, which reports information on the 30 Major League Baseball teams for the 2002 season. These data are located in .
See the attached file. o Formulate both a numerical and verbal hypothesis statement regarding your research issue. o Perform the five-step hypothesis test on data pertaining to your selection. o Describe the results of your test, and explain how the findings from this hypothesis testing can be used to answer y
First run a regression analysis using the benefits column of all data points in the data set as the independent variable and the intrinsic job satisfaction column of all data points in the AIU data set as the dependent variable. Create a graph with the trendline displayed. What is the least squares regression line equation? What
Carpet City wants to develops a means to forecast it carpet sale. The store manager believes that the store's sale are directly related to the number of new housing starts in town. The manager has gathered data from county records on monthly house construction permits and from store records on monthly sales. Monthly Carpet Sa
Prepare a report using Excel as your processing tool to process three simple regression analyses. 1. First run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable and the INTRINSIC job satisfaction column of all data points in the AIU data set as the dependent va
A. Develop a linear regression for these data and forecast carpet sales if 30 construction permits for a new homes are filed. B. Determine the strength of the casual relationship between monthly sales and new home construction by using correlation.
24. Carpet city wants to develop a means to forecast its carpet sales. The store manager believes that the store's sales are directly related to the number of new housing starts in town. The manager has gathered data from county records on monthly house construction permits and from store records on monthly sales. These data are
See attached data file. Using numerical data from the data set attached, develop one research question and formulate a hypothesis which can be tested with linear regression analysis. Complete and describe the results of the linear regression analysis on the collected data. Be sure to include the following: i. Use the hy
The Bee line Café is well known for its popular homemade ice cream, which it makes in a small plant in back of the café. People drive long distance to buy the ice cream. The two ladies who own the café want to develop a forecasting model so they can plan their ice cream production and determine the number of employees they n
12.48 In the following regression, X = weekly pay, Y = income tax withheld, and n = 35. R(squared) 0.202 Standard Error 6.816 n 35 ANOVA Table Source SS df MS f P-value Regression 387.6959 1 387.6959 8.35 .0068 Residual 1,533.0664 33
DQ3: (a) Name two advantages and two disadvantages of each of the common trend models (linear, exponential, quadratic). Explain! (b) When would the exponential trend model be preferred to a linear trend model? Explain! DQ4: One of the methods that is used to moderate (smooth) the peaks and valleys within a ti
Please answer the 11 questions posted. 1. A production manager is conducting a Z test of her assembly line. She collects a sample of 64 items from the assembly line and determines that the test's critical value is +1.96 and the Z statistic is +1.73. Based on this information she should (circle one): Accept Reject the Nu
DQ1: a) Does correlation equal causation? Does the strength of correlation depend on the direction? What is the meaning of a zero correlation? Explain your answers. DQ2: a) What is the difference between an independent and a dependent variable? What is a bivariate or simple regression model? Does a regression model
Use the data set supplied (hypertension, diabetes, cholesterol in subjects, including medication, weight, age, etc) in doc sharing and using SPSS, provide the following for the variable(s) of your choice: 1. Frequency distribution of a variable and bar graph of the same variable 2. Descriptive of a continuous : mean, median,
Please notice that we need to calculate the parameters in the linear equations through statistics and not through the mathematics [in Q1 & Q3]. Y= ax + b: here a and b must be calculated through statistical formaula and the steps must be shown. It is not accepted to just plot the data in Excel and fit a stright line to them t
The Westar hotel, a 250 room business hotel has 2 lounges on its premises: Pour Nous Lounge (for 50 people)and Gaisete - for 200. We need to forcast beverage sales. Should we take into consideration season promotional food offered during happy hour, and the presence of a piano player in Pour Nous Lounge.Room occupancy is a fact
Problem: The demand for airplane passengers (Y) is a function of a average fare (X1), the fare of the competing airline, and the annual per capital income of the passengers(X3) Passenger seat sold Fare of the Fare of the competing Annual Per Capital of the airline airline a
1. If the daily stock price, x, of United Technology is normally distributed with mean 6.56 and standard deviation 2.4, calculate the probability that in a randomly selected ay the price will be between $3.25 and $7.36. Hint: Review normal distribution. 2. An industry is comparing its performance against an industry benchmar
Perform a regression analysis on the data using Microsoft Excel.
1. The following sample observations were randomly selected. X: 4, 5, 3, 6, 10 Y: 4, 6, 5, 7, 7 a. Determine the regression equation. b. Determine the value of Y' when X is 7. c. Determine the standard error of estimate. d. Suppose a large sample is selected (instead of just 5). About 68% of the prediction
The manager of a seafood restaurant was asked to establish a pricing policy on lobster dinners. Experimenting with prices produced the following data: Average Number Sold per Day, y Price, x 200 $6.00 190
Use Megastat (and show all steps) to solve the following problem: a) Plot the data on U.S. general aviation shipments (see attachment for data). b) Describe the pattern and discuss possible causes. c) Would a fitted trend be helpful?
Use the data in the table, which shows the personal income and outlays (both in trillions of dollars) for Americans for 11 recent years. (Source: U.S. Commerce Department, Bureau of Economic Analysis) Personal income, x Personal outlays, y 5.6 4.6 5.8 4.9 6.2 5.2 6.5 5.5 6.9 5.8 7.4 6.1 7.8
The following data gives the starting salary for students who recently graduated from a local university and accepted jobs soon after graduation. The starting salary, grade jobs soon after graduation. The starting salary, grade- point average (GPA), and major (business or other) are provided. Salary $29,500 $46,000 $39,800 $36,
Calculate the regression equation using Excel, including the R Square, Slope, Intercept and the formula Y = a +bX with % Welfare as the X variable and % Passing as the Y variable.
In the following regression, x = weekly pay, y = income tax withheld and n = 35 McDonalds employees. a) write the fitted regression equation b) state the degrees of freedom for a two tailed test for zero slope and use Appendix D to find the critical value at alpha = .05 c) what is your conclusion about the slope? d) interp
I. Simple Regression to Estimate Parameters. (A) Simple regression model with sales revenue as the dependent Y-variable and R&D expenditures independent X-variable. (B) Simple regression model with profits as the dependent Y-variable and R&D expenditures independent X-variable.
An expert witness in a case of alleged racial discrimination in a state university school of nursing introduced a regression of the determinants of salary of each professor for each year during an 8-year period (n= 423) with the following results with dependent varable year (year in which the salary observed) and predictors year