See attached file. Suppose an entry level financial analyst wants to use regression models to analyze and predict the daily closing price of Microsoft stock traded in the market. To begin with the task, he was given a dataset (stockprices.MTW dataset, downloadable from GeorgiaVIEW, source: Yahoo) which contains ten years' his
See attached data files. 1. Prepare a scatter graph of S&P 500 vs. WMT, add the trend line and estimated equation. What is Beta estimate for WMT based on the equitation you've got? 2. Run regression of WMT risk premium vs. S&P 500 risk premium: RPWMT = α + βi (RPS&P 500) + εi a. What is your Beta
12. Find the area under the normal distribution curve to the right of z = -3.24. (Points : 1) 0.499 -0.499 0.999 0.001 13. Use a scatter plot to deternine the relationship between the x values and the y values. (Points : 1) No relationship Nonlinear relationship
Smart-Money magazine evaluated 65 metropolitan areas to determine where home values are headed. An ideal city would get a score of 100 if all factors measured were as favorable as possible. Areas with a score of 60 or greater are considered to be primed for price appreciation, and areas with a score of below 50 may see housing v
The problems need to be done in minitab, and have to include ordered data, rank, (xi-.5/n), z, zi MAT 332 Problem : Thirty measurements of the time - to - failure of a critical component in an electronics assembly are recorded. Determine which probability density model-Normal, lognormal,
(file is attached for better format and use in computations) Cost functions, choosing cost drivers using Excel regression analysis, and scatter plot You have been hired by Barb's Cool Cars, Inc., to help them analyze their cost accounting function. Barb opened her business in the early 1980s, making reproductions of class
The Director of a Real Estate Economics consulting firm is hired to determine better ways property values. However, the clients do not have background in statistics. In order to analyze the data (and get their questions answered), they have hired you as a statistical consultant to answer these questions: Run a complete m
Simple Linear Regression and Multiple Regression. I'd like to ask whether you think multiple regression (the use of more IV's) is always better than simple regression? Why or why not? What problems may exist with multiple regression that are not an issue for simple linear regression?
Please see the three attached files. The requirement is the Question pdf file. You just need to answer all the questions and please clearly stated the question number in front of the analysis. In each question they will ask you to forecast the time series with different methods. Examples are given there like 6 MV, 12 MV, naï
See attached files. This is an exercise requiring multiple regression analysis to be used. Details of requirements are in "The task" section of attached Asst7 document. Attached documents: 1. Asst7 = description and requirements 2. asst7.csv = dataset to be used for analysis 3. Lab manual.pdf = see
See attached file. Please see attached Xls file associated with this problem. Create dummy variables for Tuesdays, Wednesdays, Thursdays and Fridays. · Create dummy variables 09/24/2008, 11/14/2008 and 11/17/2008. · Create time variable t starting with t =1 for 08/18/2008 to t =70 for 11/21/2008. · Run multiple
Problem Set 4 Introduction You work in the shipping and logistics department for Beast Buy, an American mail order company that specializes in pet food for VERY exotic pets. Beast Buy has four warehouses/distribution centers that provide product to each of four different regions in the US; Atlanta services the southeast, Bos
City planners believe that larger cities are populated by older residents. To investigate the relationship, data and population and median age in ten large cities was collected. City Population ( In millions) Median Age Chicago Il 2.833 31.5 Dallas Tx 1.233
In regression analysis, the existence of a significant pattern in successive values of the error term constitutes: a) heteroskedasticity b) autocorrelation c) multicollinearity d) nonlinearities e) a simultaneous equation relationship
Please see attached and calculate summary output to answer the following questions: 1/ If the correlation between 2 variables is -.77 which is true. a/ There is a fairly strong negative linear relationship b/ An increase in one variable will cause the other variable to decline by 77% 2/Calculate the correlation coefficient
I have interval and ordinal data and I want to know if the interval data makes a difference in the way ordinal data is presented. Below is a survey of teachers. On the left most column is the number of students the teacher mentored in the past year. On the right columns are ordinal rankings of students that the teachers fil
Regression Hypothesis Test using Education vs. Experience and their relation to Salary Earnings: a. Formulate a hypothesis statement regarding your research issue. Please see attached excel worksheet for data. People who possess a Bachelor's degree earn a higher salary than those without a Bahelor's degree, we i
Need the three attached problems completed. From: APPLIED STATISTICS IN Business and Economics Doane and Seward Chapter 13 Section Exercises 13.2 on Page 564 13.4 on Page 566 13.6 on Page 568 13.2 Observations are taken on sales of a certain mountain bike in
See attached file for full problem and data. Use R, Minitab if possible Please give a clear explanation for the solution. Problem 13.3. Use table 13.1. (a) Calculate the logit line for X2 = 0, X3 = 1, and X5 = 1. Plot logit(Pibar) vs. age in years. (b) Plot (Pibar) vs. age in years for part (a). (c) What
See attached files. Please prepare a Logistic regression to see if a relationship between infection (or non infection) and the 4 assays for the populations.
Prepare a report using Excel as your processing tool to process 3 simple regression analyses. Create a graph with the trendline displayed for each of the 3 different regressions. 1. First run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable and the INTRINSIC j
A consumer organization wants to develop a regression model to predict gasoline mileage (MPG) based on the horsepower of the car's engine and the weight of the car (in pounds). A sample of 50 recent car models was selected, with the results shown at left. Q-12a: Write the multiple regression equation. (Use four decimals of p
See attached file. Please show all working in same excel file. A real estate company in downtown Miami would like to be able to predict the monthly rental cost for apartments, based on the size of the apartment, as defined by square footage. A sample of 25 apartments in a particular residential neighborhood was chosen.
Please refer to the attachment for details.
Consider the airline ticket data in the file P13_01.xlsx. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think should be used for forecasting? Why? b. Use simple exponential smoothing to forecast these data, using no holdout period and requesting 12 months
See attached file for datasets on low birth weight and related risk factors. * Must do a complete data analysis and report. * Can use any statistical software, but R software is preferred. If software other than R is used, then detailed descriptions of techniques used are to be provided. * Details of the requirements are i
See attached file. The file housing.xls contains sample data on the assessed price of a house (in $1,000s) and the house's floor space (in square feet). Pls Do with Excel, except where stated, and explain your results. a. Determine the proper dependent variable and then plot a scatter diagram with the dependent variable on
For Each Equation I need (F) written out.... There are two 12.48 In the following regression, X = weekly pay, Y = income tax withheld, and n = 35 McDonald's employees. (a) Write the fitted regression equation. W Y = 0.0343X + 30.7963 (b) State the degrees of freedom for a two tailed test for zero slope, and use Appe
See attached files. 9 questions: Chi-Square Tests and Nonparametric Tests/Simple Linear Regression 1. A sample of 500 shoppers was selected in a large metropolitan area to determine various information concerning consumer behavior. The results are summarized in the following contingency table: Enjoy Shopping for clothin
8. The regional transit authority for a major metropolitan area wants to determine whether there is any relationship between the age of a bus and the annual maintenance cost. A sample of 10 buses resulted in the following data. (Use of TI - 83 plus calculator permited given that steps are provided). Age of the Bus (yrs.)