The National Highway Association is studying the relationship between the number of bidders on a highway project and the winning (lowest) bid for the project. Of particular interest is whether the number of bidders increases or decreases the amount of the winning bid. Project Number of Bidders, X Winning Bid ($millions) Y
5. The number of girls who attend a summer basketball camp has been recorded for the seven years the camp has been offered. Use exponential smoothing with a smoothing constant of .8 to forecast attendance for the eighth year. 47, 68, 65, 92, 98, 121, 146 6. Monthly sales at a coffee shop have been analyzed. The seasona
Can you send me a graph for the person correlation for age vs young's. significance is 0.6 but there appears to be a trend. Can you produce a graph with best fit line as you did with sma vs age
Biomechanics of ligament and relationship between age, diagnosis and histology. The aims were to determine whether there is a link between histology. That is SMA, EVG and MT and the other parameters. And a link between the histological parameters in themselves. Hypothesis: young's modulus and/or yield and/or strain is rel
1. The number of pizzas ordered on Friday evenings between 5:30 and 6:30 at a pizza delivery location for the last 10 weeks is shown below. Use exponential smoothing with smoothing constants of .2 and .8 to forecast a value for week 11 (i.e., prepare two forecasts using each of the alpha values). Compare your forecasts using M
State Percentage who smoke Cancer incidence per 100,000 (age-adjusted) Kentucky 27.4% 498.2 Pennsylvania 22.6% 496.2 Maine 20.9% 508.9 New York 19.9%
A consumer research company collected data for 16 models of sport utility vehicles of various sizes. The research team measured the overall fuel economy and the distance between their front and rear axles (wheelbase) of each vehicle. The scatter plot and line of best fit is shown in the diagram below. (See diagram in attached
Identify a business research issue, problem, or opportunity facing a organization that can be examined using regression analysis. Then, use the Internet or other resources to collect data pertaining to your selection. Examine the regression analysis on your collected data. Begin by describing the research issue, problem, or oppo
Please see attached file. A quadratic regression model is fit to a set of sample data consisting of 6 pairs of data. Given that the sum of squares of residuals is 18.17 and that the y-values are 11, 14, 19, 22, 26, 27, Find coefficient of determination R^2
Identify a business research issue, problem, or opportunity facing a organization that can be examined using regression analysis. Begin by describing the research issue, problem, or opportunity and the accompanying data. Then, perform a regression analysis on your data using any method of computation. Finally, interpret the res
1. The linear correlation coefficient of a set of data points is 0.846. a. Is the slope of the regression line positive or negative? Explain your answer. b. Determine the coefficient of determination 2. Obtain the linear correlation coefficient x= 1,1,5,5 y= 1,3,2,4 3. A random sample of 10 stu
1. x= 1, 1, 5, 5 y= 1, 3, 2, 4 The regression equation is y = 1.75 + 0.25x 2. What can you say about SSE, SSR, and the utility of the regression equation for making predictions if a. r^2 = 1 b. r ^2 = 0?
1. Regarding a scatter diagram a. identify one of its uses. b. what property should it have to obtain a regression line for the data? 2. Line A: y= 1.5 + 0.5x Line B: y= 1.125 + 0.375x x = 1, 1, 5,5 y= 1,3,2,4 3. Hanna Properties specializes in custom-home releases in the Equestrian Estates, an exclusive subdivisio
You are interested in the prediction of apartment rent from square footage. You sample 25 apartments in the Glendale area and record the apartment rent costs and square footage. When you put this into Excel, you get the following output: Regression Analysis Regression Statistics Multiple R 0.850060796 R Sq
Please solve the attached file using Excel. (See attached file for full problem description) --- A mortgage department of a large bank is studying its recent loans. Of particular interest is how such factors as the value of the home (in thousands of dollars), education level of the head of the household, age of the head of
If needed, feel free to review the following website: http://www.psychstat.smsu.edu/MultiBook/mit08m.html Your final report needs to be compiled with regard to the results of the survey. Your final report will need to include the following: 1. In Unit 3 you tested 2 different sets of hypothesis using the database from Uni
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 the Y
1. The following sample observations were randomly selected. X: 4, 5, 3, 6, 10 Y: 4, 6, 5, 7, 7 Determine the coefficient of correlation and the coefficient of determination. Interpret. 2. The following sample observations were randomly selected. X: 5, 3, 6, 3, 4, 4, 6, 8 Y: 13, 15, 7,
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 the Y
Let's say your company is considering branching out into cold beverages. You have been asked to come up with a regression model to forecast monthly sales of cold beverages for the next year. Think about what variables you might include in your model. Your manager asks for your thoughts.
1. Maria Gomez, a research analyst in the state department of health, has undertaken a study of the possible consequences of overbuilding hospital facilities. One aspect of the study has been to calculate the effect of available hospital beds on length of patient stays. She has gathered data from 50 areas in the US; including
A high-end market research firm has contacted your boss and is trying to sell some business to your organization. Upper management does not want to appear incompetent, so they have asked you to research and explain three major ways multivariate statistics are used in a business. Provide at least 1 example of how a real compan
1. Smith Software Inc. is a computer software firm that has grown in size in recent years. To assist in its planning for future growth, you are to determine the trend of the number of accounts based upon the below. Month Number of Accounts 1 76 2 90 3 93 4
A microeconomist wants to determine how corporate sales are influenced by capital and wage spending by companies. She proceeds to randomly select 26 large corporations and record information in millions of dollars. A statistical analyst discovers that capital spending by corporations has a significant inverse relationship with
A real estate builder wishes to determine how house size (house) is influenced by family income (income), family size (Size) and education of the head of household (School) . House size is measured in hundreds of square feet, income is measured in thousands of dollars, and education is measured in years. The builder randomly
You decide to predict gasoline prices in different cities and towns in the U.S. for your term project. Your dependent variable is price of gasoline per gallon and your explanatory variables are per capita income, the number of firms that manufacture automobile parts in and around the city, the number of new businesses starts in
(See attached file for full problem description) --- An economist is interested to see how consumption for an economy (in billions) is influenced by gross domestic product (billions) and aggregate price (consumer price index). The Microsoft Excel output of this regression is partially reproduced below. SUMMARY OUTPUT
(See attached file for full problem description) An economist is interested to see how consumption for an economy (in billions) is influenced by gross domestic product (billions) and aggregate price (consumer price index). The Microsoft Excel output of this regression is partially reproduced below. SUMMARY OUTPUT Regre
(See the attached file for full problem description) An economist is interested to see how consumption for an economy (in billions) is influenced by gross domestic product (billions) and aggregate price (consumer price index). The Microsoft Excel output of this regression is partially reproduced below. SUMMARY OUTPUT R
A manager of a product sales group believes the number of sales made by an employee (Y) depends on how many years that employee has been with the company (X1) and how he/she scored on a business aptitude test (X2). A random sample of 8 employees provides the following: (see table in attached file) Referring to table for t