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
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
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
This case study involves Alumni, which are an important source of revenue for colleges and universities. If administrators could determine the factors that influence increases in the percentage of alumni who make a donation (alumni giving rate), they might be able to implement policies that could lead to increased revenue. Resea
If my dependent variable (Y) is wages If my independent variable (X) is a 2-yr. degree versus a 4-yr. degree Can you help me with a linear regression analysis if I have wages representing a 2 and 4 year degree? Those wages being: 2 yr. degree, $11,702, $24,509, $35,185, $34,746 Wages for a 4 yr. degree, $29,997, $33,959, $22
The two products that case chemical makes- cs01 and cs02 yield excessive amounts of three different pollutants: a,b,and c.
The two products that case chemical makes- cs01 and cs02 yield excessive amounts of three different pollutants: a,b,and c. the state government has ordered the company to install and to employ antipollution devices. the following table provides the current daily emissions in kg/1000liters and the maximum of each pollutant allowe
The management of Hartman Company is trying to determine the amount of each of two products to produce over the coming planning period.
I need assistance in starting and developing the linear equation. I am so lost. The management of Hartman Company is trying to determine the amount of each of two products to produce over the coming planning period. The following information concerns labor utilization, labor productivity and product profitability. Pro
14. Mr. James McWhinney, president of Daniel-James Financial Services, believes there is a relationship between the number of client contacts and the dollar amount of sales. To document this assertion, Mr. McWhinney gathered the following sample information. The X column indicates the number of client contacts last month, and th
51 True or False Questions: regression analysis, Correlation analysis, least squares model, hypothesis testing, p-value, Type I error, level of significance, Type II error, standard error
True / False _______ 1. The usual objective of regression analysis is to predict estimate the value of one variable when the value of another variable is known. _______ 2. Correlation analysis is concerned with measuring the strength of the relationship between two variables. _______ 3. The term ei in the simple linear
Please help, I am going through questions in my textbook and am having difficulties with this particular question that deals with partial f-tests. I have attached the question, and even though it may not be needed the data set where the model is drawn from. 12.18 In exercise 12.18 we give MINITAB, Megastat and excel outpu
Please see attached file for full problem description. How is the cost of a plane flight related to the length of the trip? The following table shows the average round-trip airfare paid by American Airline customers on each of 18 heavily traveled US air routes in 1996. Route Distance (miles) Cost (US $) Dallas-Austin 178 12
Assume that Q = quantity of pizza (in cents), X1 = price of pizza, X2 = tuition (in thousands of dollars), X3 = price of soft drinks (in cents), and X4 = location (1 for urban setting)
1. Assume that Q = quantity of pizza (in cents), X1 = price of pizza, X2 = tuition (in thousands of dollars), X3 = price of soft drinks (in cents), and X4 = location (1 for urban setting): Q X1 X2 X3 X4 10 100 14 120 1 12 100 16 95 1 13 90 8 110 1 14 95 7 90 1 9 110 11 100 0 8 125 5 100 0 4 125
Development of regression analysis to determine effects of sports facilities on the unemployment rate
I am writing a paper on the unemployment rate with regression analysis. The unemployment rate is my dependent variable. I figure labor market congestion, natural rate of unemployment, seasonal unemployment rate, cyclical unemployment rate, lag time of finding a new job are some of my independent variables. However, I am not j
Assume that z scores are normally distributed with a mean of 0 and a standard deviation of 1. If P(z > c) = 0.0643, find c. Assume that z scores are normally distributed with a mean of 0 and a standard deviation of 1. If P(-b < z < b) = 0.8664, find b. In a Gallop poll of 1012 randomly selected adults, 9% said that cloni
A toy company has been marketing souvenir toys in conjunction with various professional sports teams in a number of cities. Over the past few years, this experience has provided some data on the effect of advertising on sales revenues because the advertising expenditures have tended to be different in each case. Although the l
1.The coefficient of a linear regression equation indicates the change in the independent variable relative to a unit change in the dependent variable. the change in the dependent variable relative to a unit change in the independent variable. the percentage change in the dependent variable relative to a unit change
The concept of splitting of total sum of squares into sum of squares due regression and error sum of squares is discussed in the solution
Original question was related to a pharmaceutical company's development of a drug which reduces tobacco reliance. Some doses of the drug may reduce one's pulse rate to dangerously low levels. Company wants to model relationship between decrease in pulse rate y and dosage x. Differing doses were administered to 8 randomly select
Linear Programing problem involving maximization of Profit using given contstraints is solved with step by step explanation in this posted problem.
A restaurant has an ice cream counter where it sells two main products, ice cream and frozen yogurt. The restaurant makes one order for ice cream and yogurt each week, and the store has enough space for 115 gallons of both products. A gallon of frozen yogurt costs $0.75 and a gallon of ice cream costs $0.93, and the restaurant
If a long-term trend is linear, how can regression analysis be adjusted to make business decisions?
Regression: Develop a linear equation that can be used to describe how the price depends on the processor speed.
My workgroup wants to move from desktop to laptop computers so that we can work remotely without having to access our network from "foreign"computers, which is greatly frowned upon. Because we don't have an actual budget for the purchase of the laptops, we would like to present research showing justification for the type of lap
Please help with the following problem. The following data shows the retail price for 12 randomly selected laptop computers along with their corresponding processor speeds. computers speed price $ 1 2 2,689 2 1.6 1,229 3 1.6 1,419 4 1.8 2,589 5 2 2,849 6 1.2 1,349 7 2 2,929 8 1.6 1,849 9 2 2,819 10 1.6 2,669
Now that cigarette smoking has been clearly tied to lung cancer, researchers are focusing on possible links to other diseases. The data below show annual rates of cigarette consumption and deaths from coronary heart disease for several nations. Some public health officials are urging that the United States adopt a national goal
Which relationships are linear? a) Quantity Profit 0 $0 1 $1,500 4 $6,000 9 $13,500 b) Quantity Metal Used 0 0 oz 1 8 oz 2 18 oz 3 26 oz c) Quantity Fixed Expenses 0 $3,000 1 $3,000 3 $3,000 5 $3,000
Need to come up with a regression model to forecast monthly sales of cold beverages for the next year. What variables might be included in the model? Please explain regression model(s) and the reason for the variables for the model.