1. The data in the excel spreadsheet linked below give the seasonally adjusted value of total new car sales (in millions of dollars) in the United States, total national wage and salary disbursements (referred to here as compensation) (in billion dollars), and the employment level in the non-agricultural sector (in thousands) fo
The following table reports the percentage of stocks in typical portfolio in the nine quarters from 2005-2007. A Use exponential smoothing to forecast this time series. Consider smoothing constants of a=.2, .3 amd .4 What the value of the smoothing constant provides the best forecast. B. What is the forecast of the percen
The National Football League rates prospects by position on a scale that ranges from 5 to 9. The ratings are interpreted as follows: 8-9 should start the first year; 7.0-7.9 should start; 6.0-6.9 will make the team as backup; and 5.0-5.9 can make the club and contribute. The following table shows the position, weight, time in se
Using the financial ratios, plot the quarterly data and use regression analysis to examine the data by adding a linear trendline to the graphs. Construct graphs and describe the trends for the five ratio categories that are included. Use the following spread sheet (worksheet #2-7) to document your work. Use current information f
The following table gives the annual return, the safety rating (0= riskiest, 10= safer), and the annual expense ratio for 20 foreign funds (Mutual Funds, March 2000). A) Develop an estimated regression equation relating the annual return to the safety rationing and the annual expense ratio. B) Estimate the annual return fo
For this assignment, you will use the attached dataset, Grun. You will read the file into SAS and conduct seemingly unrelated regression (SUR) Analysis.
For this assignment, you will use the attached dataset, Grun. You will read the file into SAS and conduct seemingly unrelated regression (SUR) Analysis. The following steps are necessary to complete this assignment: 1. Read an Excel file into SAS and list the contents of the SAS dataset (Use Proc Contents). Note that there a
For this assignment, you will use the attached dataset, Airlines_Week_1. You will read the file into SAS and conduct a multiple linear regression analysis. The following steps are necessary to complete this assignment: 1. Read an Excel file into SAS and list the contents of the SAS dataset (Use Proc Contents). Note that th
To the Internal Revenue Service, the reasonableness of total itemized deductions depends on the taxpayer's adjusted gross income. Large deductions, which include charity and medical deductions, are more reasonable for taxpayers with large adjusted gross incomes. If a taxpayer claims larger than average itemized deductions for
Using the best-fit line below for prediction, answer the following questions: a.) What would you predict the price of Product X in volume of 150 to be (approximately)? b.) What would you predict the price of Product X in volume of 100 to be (approximately)?
Consumption Temperature 126 30 132 25 114 29 87 42 67 48 50 61 39 69 45 78 39 72 43 62 61
In a study with three treatment groups, A1, A2 and A3, and a control group, C, dummy vectors were constructed as follows: subjects in A1 were identified in D1, those in A2 were identified in D2, and those in A3 were identified in D3. A multiple regression analysis was done in which the dependent variable was regressed on the thr
Using a three-month moving average, the forecast value for October made at the end of September in the following time series would be?
Using a three-month moving average, the forecast value for October made at the end of September in the following time series would be? Question 14 Concerning the Express Delivery, Inc. problem statement, what is the value of the test statistic? Solution: Z = (50-48)/(4.9/sqrt(37)) = 2.482760216 2.18 2.48 2.68 -2.
A family doctor is interested in examining the relationship between a patient's age and total cholesterol. He randomly selects 14 of his female patients and obtains the data presented in the scatter plot, attached. a. Looking at the following scatterplot of the data, what does it tell you about the relationship between A
Using AIU's survey responses from the AIU data set, complete the following requirements in the form of a 3-page report: 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 th
Part I: Actuarial Model (Questions 1-12) An actuary wanted to develop a model to predict how long individuals will live. After consulting a number of physicians, she collected the age at death (y), the average number of hours of exercise per week (x1), the cholesterol level (x2), and the number of points that the individual'
In 2009, the New York Yankees won 103 baseball games during the regular season. The table on the next page lists the number of victories (W), the earnedrun- average (ERA), and the batting average (AVG) of each team in the American League. The ERA is one measure of the effectiveness of the pitching staff, and a lower number is better. The batting average is one measure of effectiveness of the hitters, and a higher number is better.
In 2009, the New York Yankees won 103 baseball games during the regular season. The table on the next page lists the number of victories (W), the earnedrun- average (ERA), and the batting average (AVG) of each team in the American League. The ERA is one measure of the effectiveness of the pitching staff, and a lower number
Suppose you have cross-section data on income (y) and electricity consumption (x) for three regions and you have regressed ln x on an intercept and ln y for each region and for the full sample, obtaining the following results: Estimated Intercept Std Error. Slope Std. Error SSE n Region A 0.02 0.008 1.10 0.05 48 92 Region
ASAP!! Hi Martin! I have updated this assignment with the correct data set. I also sent you a message requesting that the first assignment be changed with this data set as well. I did not realize I had sent you the incorrect data set. I am so sorry. I have been working too much, and trying to do way too much. Again, I apo
Hello Martin! Here is the next group of info for your help, and expertise. If I may ask, please do me a favor and report the results in two seperate docs so I can keep them straight. The first doc in SPSS, a determination of whether there is a correclation between age, and height. I will send the original doc way back from my
Correlation: Compute a correlation matrix that includes all continuous variables. Identify all individual correlations that are significant at the 95 percent level. Regression: Build a multiple regression model to explain the variability in the median school year. Describe the goodness of fit of your model and summarize your findings. Select at least four to seven similar independent variables from the remaining forty-nine measures and justify your selection.
I need help in conducting correlation and regression analyses using the provided SampleDataSet.xlsx. Correlation: Compute a correlation matrix that includes all continuous variables. Identify all individual correlations that are significant at the 95 percent level. Regression: Build a multiple regression model to explain t
1. A government survey conducted to estimate the mean price of houses in a metropolitan area is designed to have a margin of error of $10,000. Pilot studies suggest that the population standard deviation is $70,000. Estimate the minimum sample size needed to estimate the population mean with the stated accuracy. 2. You a
Run either correlation, regression, or discriminant analysis on your chosen data. This Application requires you to engage in data interpretation and to select the appropriate analyses for your hypotheses and for the data that you have at your disposal. Toward that end, you should consider which analyses will inform the reader an
Student Admissions Admissions want to investigate alternate means of determining who will be admitted to their university as freshmen. The admissions counselors determine that one of the best predictors of undergraduate grade point average (GPA) is a student's high school GPA. They compile information through their databases ab
Problem 3 Do the problem and answer all the questions. Hint for question: Compare the errors on the basis of the Mean Absolute Deviation (MAD)? Copy and paste the following data set in Excel to save the typing effort and possible mistakes in data entry. Year Shipments 1985 14,705 1986 15,064 1987 16,676 1988 18,061
I am having a difficult time understanding this concept as a whole. I can explain it in writing, but when it comes to calculations, it is very difficult. In the following case, I need to review the outputs for the service time data relates to predicting services times for 1, 2, 3, 4, 5, 6, and 7 copiers. I have attached the d
A shoe manufacturer is considering the development of a new brand of running shoes. The business problem facing the marketing analyst is to determine which variables should be used to predict durability (i.e. the effect of long term impact). Two independent variables under consideration are X1 (FOREIMP), a measurement of the f
a) Means, sums of squares and cross products, standard deviations, and the correlation between X and Y. b) Regression equation of Y on X. c) Regression and residual sum of squares. d) F ratio for the test of significance of the regression of Y on X, using the sums of squares (i.e., SSreg and SSres) and r_xy^2. e) Variance o
Brian, this is Bernice. I have three questions that I hope you can help me with. I have retired from WCCCD, so I am using my personal email address. I hope you can help. 1. What is simple linear regression, and why is it useful? How would we predict a raw score from a raw score? What is the difference between the intercept an
The closing stock price for each of two stocks was recorded over a 12-month period. The closing price for the Dow Jones Industrial Average (DJIA) was also recorded over this same time period. These values are shown in the following table: DJIA Stock 1 Stock 2 11,168 48.5 32.4 11,150 48.2
Researchers have collected data on the hours of television watched in a day and the age of a person. The data: Age Hours of Television 30 2 65 7 72 6 41 4 Additional Info: y= -.698 + .105x a) Find coefficient of det