See attached data file. I need to formulate a hypothesis statement which can be tested with linear regression analysis using the attached data set. Legend for the data set is posted below: X1: Account Balance in dollars X2: Number of ATM transactions in the month X3: Number of other bank services used X4: Has a de
1. The following table lists the percent yields of 25 consecutive batches (read across rows) Construct a time-sequence plot and comment on its appearance. 72.4 75.3 72.7 74.2 75.6 75.0 73.3 73.1 74.4 77.5 75.8 74.0 73.2 74.8 76.2 72.7 68.2 79.1 73.8 75.5 74.7 75.7 72.9 72.1 77.7 1b. Construct a dot diagram and calculate t
The marketing manager of a large supermarket chain would like to use shelf space to predict the sales of pet food. For a random sample of 12 similar stores, she gathered the following information regarding the shelf space, in feet, devoted to pet food and the weekly sales in hundreds of dollars. Use these data to answer questi
It has been reported that 10.3% of U.S. households do not own a vehicle, with 34.2% owning 1 vehicle, 38.4% owning 2 vehicles, and 17.1% owning 3 or more vehicles. The data for a random sample of 100 households in a resort community are summarized in the frequency distribution below. At the 0.05 level of significance, can we rej
11A is a plot and regression analysis question from Norius Chapter 20, concept exercise # 4. I do not have this as a digital copy yet, so if you choose to accept this job, I will scan the problem and email. 11B Using the Graphs menu, make a scatterplot of husband's education against wife's education (variables husbeduc and
A)Show the scatter diagram and explain whether it displays a linear relationship. b)Enter the regression equation c)Interpret the coefficients in the regression. d)Predict the amount of ice cream sold for one day with a temperature of 950C.
Please see the attached files.
A linear demand regression model found the following: Ordinary Least Squares Estimates ________________________________________ Dependent Variable : QUANTITY Independent variable: Coefficient t-statistic Constant 10 2.5 - PRICE -2
The file attached contains data on 80 colleges and universities. Among the variables included are the academic calendar type (1 = semester: 0 = other). Annual total cost (in thousands of dollars), average total score on the Scholastic Aptitude Test (SAT), room and board expenses (in thousands of dollars), whether the institu
A sociologist theorized that people who watch television frequently are exposed to many commercials, which in turn leads them to buy more, and finally increasing their debt. To test this belief, a sample of 430 families were drawn. For each, the total debt (D) and the number of hours the tv (T) is turned on per week were recorde
A market specialist is analyzing household budget data collected by her firm. The specialist's dependent variable is monthly household expenditures on healthcare (in $'s), and her independent variable is annual household income (in $1,000's). Regression analysis of the data yielded the following tables. Coefficients Standard
Robert has the following accounts on money spent on gambling and winnings: Money Spent Money Won 1000 1200 1800 2000 2500 2800 3500 4000 4200 2500 4000 4500 4600 5000 4800 5600 6000 5800 (a) (3 points) Use Excel to fit the above data into a regression line Write the equation of the line. (b) (2 points) Deter
Address questions(a)through(e)using the following information and output for multiple linear regression. The sales manager of Phanton corporation has constructed a model to evaluate the performance of the company's sales representatives. Te representatives annual sales are estimated by the person's lenght of employment (mo
Problem 1 The amount of fluid in a half-liter bottle of diet cola is normally distributed, and from past experience, the standard deviation is known to be 1.20 milliliters. A sample of 50 bottles reveals a mean weight of 502.1 ml. Construct and interpret a 90% confidence interval for the mean. Be sure to interpret the meaning
10-11 An article in the journal of Monetary Economics assesses the relationship between percentage growth in wealth over a decade and a half of saving for baby boomers of age 40 to 55 with these people's income quartiles. The article present table showing five income quartiles and for each quartile there is s reported percentag
We want to determine the factors that affect selling prices of Ford Mustangs. The statistical analysis of the data involves hypothesis testing and multiple-regression analysis. Analyses that you'll want to do are: 1. Test the hypothesis that mean price does not depend on whether the car is a convertible. (Interpret your answ
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 data set as the independent variable and the INTRINSIC job satisfaction column of all data points in the data set as the dependent variable.
Refer to the Wage data, which report information on annual wages for a sample of 100 workers. Also included are variables relating to the industry, years of education, and gender for each worker. Determine the regression equation using annual wage as the dependent variable and years of education, gender, years of work experience
An insurance company is trying to estimate the average number of sick days that full-time food-service workers use per year. They would like to develop a model to predict the number of sick days based on whether any children between the ages of 4 and 12 years old reside at home with them. The analysis produced the following outp
See attached data file. Terry and Associated is a specialized medical testing center in Denver, Colorado. One of the firm's major sources of revenue is a kit used to test for elevated amounts of lead in the blood. Workers in auto body shops, those in the lawn care industry, and commercial house painters are exposed to large a
10-79 A regression was carried out aimed at assessing the effect of the offer price of an initial public offering (IPO) on the chances of failure of the firm issuing the IPO over various time period from the time of offering ( the maximum length of time being 5 years). The sample was of 2,058 firms, and the regression slope es
Chapter 11: Section Exercises #3, 4, 6, 14 , 16 NO P-Values are necessary for these problems 11.3 Semester GPAs are compared for seven randomly chosen students in each class level at Oxnard University. Does the data prove a significant difference in mean GPAs? GPA1 GPA for Randomly Selected Students in Four Business Majo
1 How do I find the 98% confidence interval for the mean of the following sample of 10: 91, 82, 66, 94, 110, 80, 90, 75, 88, 84 2 2. A farmer wanted to test a new diet on his pigs and he wanted to be 99% confident that the average weight gain would be within 2 pounds. The standard deviation is 16.5 How many pigs should g
See data file attached. Management at the Texas Christian University physical plant is interested in reducing the average time to completion or routine work orders. The time to complete is defined as the difference between the date of receipt of a work order and the date closing information is entered. The number of labor hou
Prepare a report using Excel as your processing tool to process three simple regression analysis. 1. 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 data set as the dependent variable
I need help with analyzing and evaluating the results from the attached regression. Please review the attached for linear model. Price is represented as cents per gallon.
See attached file. 12.49 In the following regression, X = monthly maintenance spending (dollars), Y = monthly machine downtime (hours), and n = 15 copy machines. (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
See attached files Phase III, IV & V Chi-Square, ANOVA & Regression Analysis III. In this phase you will investigate the relationship between a respondent's view (Interest) of the recent move and his/her demographic characteristics: 1. Run Chi-Square analyses between a respondent's view (Interest) and the respondent's dem
Please use use the templates attached. 1. (a) Suppose you want to estimate the mean percentage of gain in per share value for growth-type mutual funds over a specific 2-year period. Ten mutual funds are randomly selected from the population of all the commonly listed funds. The percentage gain figures are shown below (negativ
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