The number of Employees of a major high tech company for 1999-2004 is given below: Year Employees (in 000) 1 45, 600 2 42,200 3 41,100 4 39, 300 5 34,300 6 30,300 Determine the least square trend equation. Estimate the number of employees in 2008. By how much the number of employees decreases (or in
Ann's furniture store is a family business that has been selling to retail customers in the Chicago area for many years. They advertise extensively on radio, TV, and the Internet, emphasizing the low prices and easy credit terms. The owner would like to review the relationship between sales and the amount spend on advertising.
A town assessor was trying to determine a relationship between the size of a parcel of land (x) and the selling price (y) the assessor used the data in the following table. Size in acres (x) Selling price in thousands of dollars (y) 0.5 25 1.0 40 1.5 55 2.0 65 2.5 75 3.0 80 a. Draw a scatter diagram. Does the sellin
1. You are a college admissions officer, and you have the following data: HS GPA College GPA 2.00 2.50 2.50 1.80 2.70 1.50 3.00 2.00 3.10 2.50 3.20 2.50 3.50 3.00 3.70 2.80 3.75 3.00 3.80 3.90 3.85 4.00 4.00 3.75 These, of course, are High School GPAs and College GPAs (at the end of First Year
Problem A high-tech company wants to study the relationship between salary (Y) and some factors such as degree obtained (1=bachelor's degree, 2=master's degree. 3=doctoral degree), year of experience, and the number of persons currently supervised. The data is given as follows. The first column denotes the salary (in thousand
Using Excel as your processing tool, work through three simple regression analyses. First run a regression analysis using the BENEFITS column of all data points in the data set as the independent variable and the INTRINSIC job satisfaction column of all data points in the data set as the dependent variable. Create a graph wi
Using Excel, prepare a linear regression equation for the following data and use it for prediction. A random sample of study times for 12 students tracks hours of study for their advanced tax exam and the percentage grades they subsequently earned on their tax exam. Assume that study times have been compiled over a weekend.
Briefly state what question you are trying to answer when you use simple regression. Please use your own words and not text book...I really need to understand this in the simplest terms possible. Like kinder garden...
1. DEFINE: Correlation 2. Students were asked the following: Imagine that you lost (X dollars) amount of money. How much (Y dollars) would you pay to get it back? Imagine that these are the answers. Calculate the correlation coefficient for the following X - Y pairs. X___ __Y _ 10.00
Your employer asks you to determine whether current salaries (DV) can be predicted from years of experience (IV) What is the right statistical test one should use and why?
Calculate the following coefficient to see if height and shoe size are correlated: Subject 1: 70 inches, size 90.0 Subject 2: 62 inches, size 6.5 Subject 3: 66 inches, size 8.0 Subject 4: 69 inches, size 7.5 Subject 5: 72 inches, size 8.5
I need help with the attached. It deals with scatter plots. Thank you for you help. ------------------------------------------------------------------------------------------ 1. A value of r = -0.851 shows that there is very little relationship between the two variables being compared. 2. A value of r = 0.158 shows that
Problem 1: In an earlier assignment, you estimated a simple t-test to ascertain if IMF lending programs in Latin America served to attract or deter foreign direct investment. Of course, the principal problem with this result is that we really can't say much definitively because we don't control for alternative explanations.
Managerial Economics Assignment Below are data on quantity produced at a group of shirt manufacturing plants. Each plant also reports its total cost. This exercise tests your knowledge of empirically verifying economic theory of short-run production cost. a. What is the theoretical regression equation of the short-run to
Answer all three of the questions below. You must show all of your work .Please do this assignment as a Word document with SPSS output pasted where appropriate. Problem 1: Operationalizing variables can be a challenge. One measure of a country's human rights record is a measure known as the Political Terror Scale. This var
Data: This data consists of a random sample of 113 hospitals selected from the original 338 hospitals surveyed. Each line of the data set has an identification number and provides information on 11 other variables for a single hospital. The data presented here are for the 1975-76 study period. The 12 variables are: Va
Question 1 A random sample of 85 students in Chicago's city high schools take a course designed to improve SAT scores. Based on this sample, a 90% confidence interval for the mean improvement μ in SAT score for all Chicago city high school students taking this course is found to be (72.3, 91.4). Which of the following st
This is a problem #13, chapter 9 - Regression Analysis, from the textbook by Cliff Ragsdale, "Spreadsheet Modeling and Decision Analysis". This problem requires the use of Excel and the add-in, called Solver. The course is Excel-based and Solver is the optimization application used for all problems. This problem has (a),(b),(c)
. 1. Describe in your own words what is meant by "line of best fit." 2. Answer the following: a. What is the relationship between the sign of the correlation coefficient and the sign of the slope of the regression line? b. As the value of the correlation coefficient increases from 0 to 1, or decreases from 0 to -1, how d
1. A researcher selects a random sample of college students and measures the number of hours they spend watching television per week and their grade point average. The results are as follows: X Y Subject # TV hours GPA 1 50 1.90 2 20 2.20 3 19 2.40 4 10 3.30 5 9 2.90 6 14 2.50 7 7
In the following regression, X = total assets ($ billions), Y = total revenue ($ billions), and n = 64 large banks. (a) Write the fitted regression equation. (b) State the degrees of freedom for a two-tailed test for zero slope, and use Appendix D to find the critical value at α= .05. (c) What is your conclusion about the
What is the difference between an independent and a dependent variable? Does a regression model imply causation? Why or why not? Provide an example which provides and independent and dependent variable from your place of work.
We want to determine the factors that affect selling prices of Ford Mustangs. The statistical analysis of the data involves hypothesis testing and multiple-regression analysis. The data is attached. Analyses that you'll want to do are: 1. Test the hypothesis that mean price does not depend on whether the car is a convertibl
You are the CFO for Mark's Company. Intuitively you know that there is a relationship between sales and collections in your company. You want to design a model that will allow the company to predict collections. Historical credit sales data is shown for the current month, March, and the previous months. As the CFO you wil
Salsberry Realty sells homes along the east coast of the U.S. One of the questions most frequently asked by prospective buyers is: If we purchase this home, how much can we expect to pay to heat it during the winter? The research department at Salsbury has been asked to develop some guidelines regarding heating costs for singl
Using the SPSS data file "employee data" answer the following questions. First run a regression analysis identifying "salary" as the dependent variable and "educ", "jobcat", "salbegin", "jobtime", "prevexp", and "minority" and the independent variables. a) What is the regression equation? b) What variables contr
Suppose a random sample of twelve families had the following annual income and savings. Using SPSS, answer the following questions. Family Income, I (in Thousands) Savings, S (in Thousands) 1 22 2 2 18 2 3 17 1.6 4 27 3.2 5 30 3.0 6 21 2.0 7 23 1.9 8 28 3.1 9 15
It has been suggested that treatment of a plastic used in optic lenses will improve wear. Four different treatments are to be tested. To determine whether any differences in mean wear exist among treatments, 28 castings were made from a single formulation of the plastic and seven castings were randomly assigned to each of the
Problem 1 The following data represents the yearly movie attendance (in billions) in the United States from 1999 to 2008: Year Attendance 1999 1.47 2000 1.42 2001 1.49 2002 1.63 2003 1.57 2004 1.53 2005 1.41 2006 1.45 2007 1.47 2008 1.55 a. Plot the time series. b. Fit a three-year moving average to the dat
You have been hired as a data analyst for the Philadelphia Police Department. The Department needs your help in determining whether they should change their current allocation of police officers on patrol for two precincts. They provide you with the data for the past 20 weeks. For each week there is a count of the number of p