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
(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
Using numerical data from the attached data set, develop one research question and formulate a hypothesis which can be tested with linear regression analysis. (Research question is Whether age influences the purchase of domestic or imported vehicles) Perform a regression hypothesis test on the data in the attachments Price Pr
Quick Stab Collection Agency (QSCA) collects bills in an eastern town. The company specializes in small accounts and avoids risky collections, such as those in which the debtor tends to be chronically late in payments or is known to be hostile. The business can be very profitable. QSCA buys the rights to collect debts from th
I need some help with Forecasting/Demand Planning. Can you assist me with the following attached information on an excel spreadsheet. Thank you! ----------------------------------------------------------------------------------------------------------------------------------------------- Forecasting/Demand Planning
1. Jake's Country Club would like to determine the best way to allocate a monthly advertising budget of $1000 between newspaper advertising and radio advertising. Management decided that at least 25% of the budget must be spent on each type of media, and that the amount of money spent on local newspaper advertising must be at le
Linear Programming Applications: The Two-Rivers Oil Company near Pittsburg transports gasoline to its distributors by truck. The company recently contracted to supply gasoline distributors in southern Ohio, and it has $600,000 available to spend on the necessary expansion of its fleet of gasoline tank trucks. Three models of
The amounts spent in vending machines in the united states, in billions of dollars, for the years 1999 through 2003 are given below. Determine the least squares trend equation, and estimate vending sales for 2005. Year code vending machine sales 1999 1 17.5 2000 2 19.0
1. Testing for a linear Correlation: Use the scatterplot and the linear correlation coefficient r to determine whether there is a correlation between the two variables. x 1 2 2 5 6 y 2 5 4 15 15 2. Finding the Equation of the Regression Line: Use the given data to find the equation of the regression line. x 1 2
Perform a linear regression, 8 month moving average & 3 month moving average forecasting technique to see which is most accurate for the new quarter 11 if quarter 11 sales are 172,000 units Quarter Quarter Demand Shown in Thousand (1000) units 1 121 2 132 3
For the y and x values listed, obtain the simple linear regression equation, then analyze the residuals by: a. constructing a histogram b. using a normal probability c. plotting the residuals versus the x values d. plotting the residuals versus the order which they were observed. Do any of the assumptions of the si
The U.S. Congress enacted legislation in 2005 authorizing Block Grants to cities as part of an Anti-Crime initiative. The grant monies are to be used to hire additional police officers for conducting beat patrols in high crime areas. As part of the determination for how much money to grant, nine cities in New Jersey were part of
Please provide solution in EXCEL format. PRODUCTION. Minnesota Fabrics produces three sizes of comforters (full, queen, and king size) that it markets to major retail establishments throughout the country. Due to contracts with these establishments, Minnesota Fabrics must produce at least 120 of each size comforter daily.
BLENDING. Corless Chemical Company can purchase up to 1000 gallons of each of three pesticide compounds, which it blends to make two different commercial products, which it blends to make two different commercial products: Bugoff, a plant pesticide, and Weedaway, a lawn pesticide. Bugoff sells for $5 per quart and Weedaway for
Compaids, Inc. manufacturers two types of slide-out keyboard trays for use with personal computers. Model C15 is designed for desktop use. It can stand alone, or it can fit under a desktop CPU or monitor. Model UN8 is designed to be mounted underneath a desk with screws. Both units are manufactured from laminated particle bo
A) Explain why a confidence interval for the slope or intercept would be equivalent to a two-tailed hypothesis test. (b) Why is it especially important to test for a zero slope? -------------------------------------------------------------------------------------------------------------------------------------------- DATA SET
Need help with the following problem. Need solution in excel. RESTAURANT OPERATION. Jackson's Sports Bar and Grill would like to minimize the cost of installing television sets throughout the restaurant so that it can accommodate a potential viewership of at least 750 patrons. It is considering purchasing two models of Son
The following table summarizes data between money spent on gambling and winnings for Robert. Money Spent Money Won x y 12 62 10 54 16 86 18 100 15 80 10 57 5 26 12 60 22 105 25 140 Develop a linear regression equation for these data and forecast how much money Robert will win if he spends $30.
What is the difference between an independent and a dependent variable? Does a regression model imply causation? Why or why not?
Dot sells life insurance for prudence insurance company, she sells insurance by making by making visits to her clients homes. Dot believes that the number of sales should depend, to some degree, on the number of visits (x) she made each week and the number of people(y) who bought insurance that week, For a rando sample of 1.5 su
2.Charleston Textiles produces two types of cotton cloth: denim and corduroy. Corduroy is a heavier grade of cloth and, as such, requires 7.5 pounds of raw cotton per yard, whereas denim requires 5 pounds of raw cotton per yard. A yard of corduroy requires 3.2 hours of processing time; a yard of denim requires 3.0 hours. Althoug
ACT Networks, Inc. develops, markets, manufactures, and sells integrated wide-area network access products. The following are annual sales data (in millions of dollars) from 2002 to 2007. Based on this data develop a linear trend equation for this time series. What is the firm's average increase in sales per year? Provide a fore
The Savannah Manufacturing Company produces two types of kayaks on two assembly lines. Assembly line 1 has 100 available hours, and assembly line 2 has 42 available hours. Each kayak requires 10 hours of processing time on line 1, while on line 2 kayak A requires 7 hours and kayak B 3 hours. The profit for kayak A is $600 and th
I need help running multiple regression analysis in Minitab. Please do not use Excel. See attached files. One is in WORD, the other is MINITAB. Question 1 - Background to Century National Bank The bank would like to know the characteristics of checking account customers. What is the balance of a typical customer? How
Solve the following linear programming model graphically: Minimize Z = 8X1 + 2X2 S.T. 2X1 - 6X2 ≤ 12 5X1 + 4X2 ≥ 40 X1 + 2X2 ≥ 12 X2 ≤ 6 X1, X2 ≥ 0
Compare the ROI over time but we don't have the ROI for a period of time. Maybe we could compare employees to net income and see if there is a regression between the number of employees and the net income of a company. **Linear Regression Analysis**
PRICE VS. AGE: A LINEAR REGRESSION: investigate the relationship and perform a linear regression statistical analysis on sample data collected. The objective behind the analysis is to answer the research question of is there a relationship between the age of car owners and the price of their cars. Hypothesis Statement One o
Solve the problems. Show all steps. 1. Using the data from 1996-1998, the annual number of cars sold at a certain dealership can be modeled by the formula Y=3x +2 Where y is the number of cars, in thousands, sold x years after 1996. According to this formula, in which years will the number of cars sold exceed 29 thousan
Based on the attached data from the U.S. Department of Agriculture, explore the relationship between the number of farms (X) and the average size of a farm (Y) in the United States between 1950 and 2003. Specifically, generate a simple linear regression model and interpret it. See the attached file.