See attached data file. Using the attached Excel numerical data, develop a research question, formulate a hypothesis, and perform a linear regression analysis and hypothesis test on the data. Include raw data tables and the results of computations, using both graphical and tabular methods of displaying data and results.
A university has studied the relationship between the GPA (grade point average) of its graduates and StartSal, their starting salaries (in thousands of dollars). A sample of seven graduates was randomly selected. The data collected and output from Excel are shown below: MKTGrad GPA
Please see attached file to view the tables. 1. The Y-intercept (b0) represents the A) variation around the sample regression line. B) predicted value of Y when X = 0. C) predicted value of Y. D) change in estimated average Y per unit change in X. 2. The slope (b1) represents the A) predicted value of Y when X =
For Problems 16 and 26, construct a scatter plot, find the value of the linear correlation coefficient r, and find the critical values of r from Table A-6 using x = 0.05. Determine whether there is sufficient evidence to support a claim of a linear correlation between the two variables. (Save your work because the same data se
1. Create a line graph illustrating actual and projected revenues from 2002 to 2013 for a budget meeting. 2. a. Explore the possibility of a linear relation between advertising expenditures and three-month sales revenue. Does there seem to be a strong linear relationship, based on a scatter plot and the correlation? b. Build a linear model to represent the relation between advertising and revenue. What revenues would the model predict for expenditures of $1.3 million and $6 million?
1. In creating a 4 year forecast for your company, you want to project future revenue based on the historical revenue provided. Projected Revenue (in 000's) year Actual Revenue (in 000's) Using FORECAST Using TREND 2002 185,623 2003 196,742 2004 199,240 2005 210,367 2006
See the attached article file (Sharma & Sharma 2010, Process Integration in IT Portfolio Management). What integration strategies are proposed in the Sharma & Sharma article? Are there any benefits or limitations?
A professor wants to know whether the number of absences a student has and the grade the student gets on a final exam are associated. She randomly selects 100 of her students and gathers the following information: Grade Absences A B C D F 0 10
31. Which of the following mathematical relationships could be found in a linear programming model? Choose YES if the relationship could be, and NO if it could not. A. YES B. NO -28B + 7A = 45 1. A or B 12B - A â?¤ 10 2. A OR B AB > 10 3
Scenario: A sample of twenty automobiles was taken, and the miles per gallon (MPG), horsepower and total weight were recorded. Develop a linear regression model to predict MPG using horsepower as the only independent variable. Develop another model with weight as the independent variable. Which of these two models is better? Exp
See attached files. Only questions 4 through 10 are required. Consider the linear regression equation which predicts expenditures on imported goods based on personal disposable income. They are both measured in billions of 1982 dollars. Y'=-261.09+0.2453xt (31.327) (0.0147) to=8.33 and t1=16.616 4. According to
See attached file. Four Linear Programming problems: A company produces two products that are processed on two assembly lines. Assembly line 1 has 100 available hours, and assembly line 2 has 42 available hours. Each product requires 10 hrs of processing time on line 1, while on line 2 product 1 requires 7 hours and product
A simple linear regression equation, Y=a be, estimated a computer program, produced output: Dependent Variable:S R- Square F-Ratio P-Value On F Observations: 25 0.7482 68.351 0.0001 Variable Parameter Standard Estimate Error T-Ratio
Application of simple linear regression analysis to the estimation of a demand equation has yielded the following Q = 24 - 2P If the current product price is P=$6 and the quantity sold per time period is Q = 10, then the erro (e) for the current time period is equal to (actual quantity sold - estimated quantity sold)? 1
If the t ratio for the slope of a simple linear regression equation is equal to 1.614 and the critical value of the t distribution at the 1% and 5% levels of significance, respectively, are 3.499 and 2.365 is the slope: not significantly different from zero significantly different from zero at both the 1% and 5% levels sign
Construct a scatterplot of the raw data. Then, run the correlation/regression program. Commuters and Parking Spaces: Listed below are the numbers of commuters and the number pf parking spaces at different Metro - North railroad stations. Is there a linear correlation between the number of commuters and the number of parking
A company is interested in knowing which are the potential sales next year if you use $ 20,000 in advertising expenses. The company uses the information from previous years to make its sales forecast. The data are: Year Sales Advertising $000 $ 000 1 15 2 2 25 3 3 45
A glassblower makes glass decanters and glass trays on a weekly basic. Each item require 1 pound of glass, and the glassblower has 15 pounds of glass available each week. A glass decanter requires 4 hours of labor, a glass tray requires only 1 hour of labor, and the glassblower works 25 hours a week. The profit from a decanter i
Maxwell Manufacturing makes two models of felt tip marking pens. There are 3 processing steps required for the pen production. Times (hours) are given in the table below. Capped Clickable Available Extrusion 3 5 45 Ink Fill 4 2 36 Molding 4 1 30
1. For each company, fit an exponential trend curve to their sales data. 2. For which company does exponential growth have the best fit to revenue growth? 3. For which company does exponential growth have the worst fit to revenue growth? 4. For each company, estimate the annual percentage growth rate for revenues
Problem 11-17 Horizon Wireless, a cellular telephone company, is expanding into a new era. Relay towers are necessary to provide wireless telephone coverage to the different areas of the city. A grid is superimposed on a map of the city to help determine where the towers should be located. The grid consists of 8 areas labeled
The Artful Dodger Sports Shop is sponsoring a weekly boomerang throwing contest as part of its spring promotions. Anyone may enter, but the boomerangs uses must be purchased at the The Artful Dodger. Because a smooth finish on the boomerang is essential for accurate flight, most entrants to the contest are expected to buy a new
1. Use the given information to find the P-value. The test statistic in a right-tailed test is z =1.26 P-value =____ (Round to four decimal places as needed) 2. Suppose IQ scores were obtained from randomly selected couples. For 20 such pairs of people, the linear correlation coefficient is 0.904 and the equation of the
The Livewright Medical Supplies Company has a total of 12 salespeople it wants to assign to three regions - the South, the east, and the Midwest. A salesperson in the South earns $600 in profit per month for the company, a salesperson in the Eat earns $540, and a salesperson in the Midwest earns $375. The southern region can hav
A company produces two products that are processed on two assembly lines. Assembly line 1 has 100 available hours, and assembly line 2 has 42 available hours. Each product requires 10 hours of processing time on line 2, while on line two product 1 requires 7 hours and product 2 requires 3 hours. The profit for line 1 is $6 per u
Sales of single family residence increasing in Sin City. This is more pronounced in older communities with cheaper homes, although people are still willing to pay up to live in never communities. Attached spread sheet contains info about location, number of offers made on homes, sq ft of homes, whether home made of brick or no
Assume Acme Inc. has hired you to be the product manager for their Segways in the Zambia division. Part of your responsibilities is to determine how to promote Segways in Kitwe for the coming month. You have decided that one segment of the promotional campaign will involve purchasing ad time on the four largest radio stations
A suburban hotel derives its gross income from its hotel and restaurant operations. The owners are interested in the relationship between the number of rooms occupied on a nightly basis and the revenue per day in the restaurant. Below is a sample of 25 days (Monday through Thursday) from last year showing the restaurant income a
2. A college bookstore must order books two months before each semester starts. They believe that the number of books that will ultimately be sold for any particular course is related to the number of students registered for the course when the books are ordered. They would like to develop a linear regression equation to help pl
Bivariate Regression a) Use Excel to make a scatter plot of the data. (b) Select the data points, right-click, select Add Trendline, select the Options tab, and choose Display equation on chart and Display R-squared value on chart. (c) Interpret the fitted slope. (d) Is the intercept meaningful? Explain. (e) Interpret the R2.
(a) Use Excel to make a scatter plot of the data. (b) Select the data points, right-click, select Add Trendline, select the Options tab, and choose Display equation on chart and Display R-squared value on chart. (c) Interpret the fitted slope. (d) Is the intercept meaningful? Explain. (e) Interpret the R2. Moviegoer Spendi
You are the director of product development for the Frobozz magic thermometer company. You need to determine the markings for the scale printed on the thermometer tube. You take a tube and fill it with mercury, then measure the height of the mercury above a mark near the bottom of the tube at seven different temperatures. You p