6. Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable) and X (independent variable). ANOVA Source df SS Regression 1 110 Residual 8 74 Total 9 184 Coefficients Standard Error t-stat Intercept 39.222 5.943 x -0.5556 0.1611 a. What has been the sample size f
ââ?¬Æ' In order to determine whether or not the sales volume of a company (Y in millions of dollars) is related to advertising expenditures (X1 in millions of dollars) and the number of salespeople (X2), data were gathered for 10 years. Part of the regression results is shown below. Analysis of Variance (incomplete)
Welcome to the fifth SLP of the course. For this module I am again going to refer you to the data you have been collecting. Answer the following questions in reference to your data. Can you perform a multiple regression analysis with the data you have been collecting without changing that data or adding to it? Why or why
See attached data file. Use simple regression to determine the extent to which your stock's closing price can be determined from the closing value of the DJIA. As before, you should include a copy of the data you've collected to date. In your SLP upload, include a screen shot of your Excel output. SLP Assignment Expecta
I would like to check my answers against the following questions: Referring to the data, tomyld2.xls, discussed in the square-root regression model. Using EXCEL, PHStat2 or other statistical program/means answer the following: When applied a quadratic term on fertilizer and performed the quadratic regression analysis,
Please solve the following pb: In a paper that appeared four years later, Halperin et al.  reexamined the Framingham data analysis by Truett et al.  using a logistic model. Halperin et al. analyzed several subsets of the data; for this problem we abstract the data for men aged 29 to 39 years, and three variables
Suppose you are given data from a survey showing the IQ of each person interviewed and the IQ of his or her mother. That is all the information you have. Your boss has asked you to put together a report showing the relationship between these two variables. What could you present and why?
The problem set has been attached. It has to do with Regression and forecasting. Create a graph of Sales over this time period (Quarter 1 of 1986 through Quarter 1 of 2001) What do you see happening to Coca Cola sales over this time period? Run a simple linear regression of Sales on Time Period (recode the time period v
Road Construction is considering two suppliers to deliver 10,000 concrete pillars for their next construction project. The two suppliers are geographically dispersed and the management believes the proximity to Road Construction plays an important role in delivering the pillars on time. Another important characteristic is the sc
given the following data x 3, 1, 4, 4, 5 y 2 -2, 5, 4, 8 Determine SSxx, SSxy, SSyy
BC LUMBER is trying to obtain a better prediction on the volume of its trees. A sample of trees of various diameters were cut and the diameters, heights and volumes were recorded. The results are given below. DIAMETER: Diameter in inches at 4.5 feet above ground level HEIGHT: Height of the tree in feet VOLUME: Volume
The following data gives the annual rent per square foot for office space (X in $) and the associated occupancy rate (Y as a %). X Y 12 83 17 77 9 92 15 82 11 88 7 90 19 75 10 90 13 83 14 78 16 75 8 91 Please Use Minitab 1. Generate a scatterplot fo
1. Suppose that a researcher, using wage data on 250 randomly selected male workers and 280 female workers, estimates the OLS regression Wage = 12.52 + 2.12 male ; R^2 = 0.06 ;? = 4.2 and (0.23) (0.36) where the quantity in parentheses is the standard error of the estimated coefficient. wage is measured in do
Dear OTA â?" I need a solution or method to estimate the hourly electrical load for the State of Georgia during 1994, using Regression Modeling Techniques. Given will be Excel tables that provide Georgiaâ??s actual hourly weather and average electrical load for the years 1992 and 1993 (9293w_ld) and Georgiaâ??s actual
Need help in working out the problems attached so that I can do the rest, thanks.
In New Jersey, Banks have been charged with withdrawing from countries having a high percent of minorities. To substantiate this charge, P.D. Ambrosio and S Chambers (1995), present in the data in shown at the bottom: A.) Determine if there is significant relationship between X and Y. B.) Describe the exact nature of any r
See attached data file. BC LUMBER harvests trees throughout the U.S. and Canada. They need to be able to estimate the amount of timber in a given area of forest. More specifically they need a quick and easy way to determine the volume of any given tree. Unfortunately, it is difficult to measure the volume of a tree directly.
See the attached file. 1) Blay mount Amateur Dramatic Society is staging a play and wants to know how much to spend on advertising, by getting a better understanding of the relationship between advertising and attendance. For the past 11 productions they have recorded their spending on advertising (in $) and the size of their a
1. Explain the difference between a standard deviation and the standard error of estimate 2. Given the regression line in the graph below for question #11 on pg. 160. (scan 3 file attachment) (part 2) draw the regression line for a = -2 and b = -.24 3. To determine the relationship between speed and precision in driving
Must see attachment for number 2. 1) What are the components of a time series? What external factors might affect each of the different components? In number 2, I need assistance step by step details in understanding how to work statistics problems in words of interpretation (that helps explain the results and what it r
In considering doing a logistic regression using the Enter method, it was suggested that I may want to consider doing a sequential LSR or stepwise logistic regression instead. What exactly are the advantages and disadvantages of each of these options, and what criteria should I use in order to decide which method is best?
See attached data file. 6.28. Based on the Current Population Survey (CPS) of March 1995, Paul Rudd extracted a sample of 1289 workers, aged 18 to 65, and obtained the following information on each worker: Wage = hourly wage in $ Age = age in years Female = 1 if female worker Nonwhite = 1 if a nonwhite w
Using the data set below complete the following: TEST #1: Regression Analysis - Benefits & Intrinsic Perform the following Regression Analysis, using a .05 significance level. Run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable. and the INTRINSIC job satisfa
See attached file. Are gasoline prices higher during the height of the summer vacation season? The table stored in the file unleaded.xls contains the mean monthly prices (in dollars per gallon) for unleaded gasoline in the United States from 2000 to 2005. a) Construct a time series plot b) Develop an exponential tren
*****I need helllllllp. Attach is the data key, the data tool and the template. It has to be Original not copied because they change the data numbers each session so whatever is in the library will not work for this assignment. ***** I will need help with the Interpretation of the numbers and the conclusion. How can
See attached data file. You want to develop a model to predict the selling price of homes based on assessed value. A sample of 20 recently sold single-family houses in a small city is selected to study the relationship between selling price (in thousands of dollars) and assessed value (in thousands of dollars). The houses in
Hello. Could you please provide your feedback to these Statistics questions? Thanks. ----------------------------------------------- 1 - Give the meaning (define) of: Reliability of a sample: Validity of a sample: Practicality of a sample: Precision of a sample: Accuracy of a sample: Why should we be concerned about the
The CEO has asked you for a report, based on his desire to have a 95% level of confidence, whether the target market will have a product satisfaction score of at least 4.5. A sample of 20 adults from the target market had an average score of 4.7, with a standard deviation of 0.25. Using a t-test, and assuming a fairly normal dis
Using Microsoft Excel, create a correlation analysis of Wal-Mart's annual net income over the past 10 years compared with Sears's annual net income over the past 10 years and interpret the results. Do both companies' net incomes fall during a recession? Using Microsoft Excel, create a multiple regression equation that expl