Question one Question two Brawdy Plastics, Inc., produces plastic seat belt retainers for General Motors at their plant in Buffalo, New York. After final assembly and painting, the parts are placed on a conveyor belt that moves the parts past a final inspection station. How fast the parts move past the final inspection station depends upon the line speed of the conveyor belt (feet per minute). Although faster line speeds are desirable, management is concerned that increasing the line speed too much may not provide enough time for inspectors to identify which parts are actually defective. To test this theory, Brawdy Plastics conducted an experiment in which the same batch of parts, with a known number of defective parts, was inspected using a variety of line speeds. The following data were collected. Question three Companies in the U.S. car rental market vary greatly in terms of the size of the fleet, the number of locations, and annual revenue. In 2011 Hertz had 320,000 cars in service and annual revenue of approximately $4.2 billion. The following data show the number of cars in service (1000s) and the annual revenue ($millions) for six smaller car rental companies. e. Fox Rent A Car has 11,000 cars in service. Use the estimated regression equation developed in part (c) to predict annual revenue for Fox Rent A Car. Round your answer to nearest whole value. ______ million Question four A large city hospital conducted a study to investigate the relationship between the number of unauthorized days that employees are absent per year and the distance (miles) between home and work for the employees. A sample of 10 employees was selected and the following data were collected. Question five Excel one Concur Technologies, Inc., is a large expense-management company located in Redmond, Washington. The Wall Street Journal asked Concur to examine the data from 8.3 million expense reports to provide insights regarding business travel expenses. Their analysis of the data showed that New York was the most expensive city, with an average daily hotel room rate of $198 and an average amount spent on entertainment, including group meals and tickets for shows, sports, and other events, of $172. In comparison, the U.S. averages for these two categories were $89 for the room rate and $99 for entertainment. The table in the Excel Online file below shows the average daily hotel room rate and the amount spent on entertainment for a random sample of 9 of the 25 most visited U.S. cities (The Wall Street Journal, August 18, 2011). Construct a spreadsheet to answer the following questions. I could not save the excel data (next page) on an excel sheet so please kindly input all data on an excel to complete the questions. I only need the final answers for all excel questions. I don’t need any excel spread sheets. a. Provide an interpretation for the slope of the estimated regression equation (to 3 decimals). b. The slope of the estimated regression line is approximately dollar . So, for every in the hotel room rate the amount spent on entertainment increases by $ . c. The average room rate in Chicago is $128, considerably higher than the U.S. average. Predict the entertainment expense per day for Chicago (to whole number). $______ Excel two An important application of regression analysis in accounting is in the estimation of cost. By collecting data on volume and cost and using the least squares method to develop an estimated regression equation relating volume and cost, an accountant can estimate the cost associated with a particular manufacturing volume. In the Microsoft Excel Online file below you will find a sample of production volumes and total cost data for a manufacturing operation. Conduct a regression analysis to explore the relationship between total cost and production volume and then answer the questions that follow. a. Compute b1 and b0 (to 1 decimal). b1 b0 Complete the estimated regression equation (to 1 decimal). = b. + x According to this model, what is the change in cost (in dollars) for every unit produced (to 1 decimal)? c. Compute the coefficient of determination (to 3 decimals). Note: report r2 between 0 and 1. r2 = What percentage of the variation in total cost can be explained by the production volume (to 1 decimal)? % d. The company's production schedule shows 500 units must be produced next month. What is the estimated total cost for this operation (to the nearest whole number)? $ Excel three A sales manager collected data on annual sales for new customer accounts and the number of years of experience for a sample of 10 salespersons. In the Microsoft Excel Online file below you will find a sample of data on years of experience of the salesperson and annual sales. Conduct a regression analysis to explore the relationship between these two variables and then answer the following questions. a. Compute b1 and b0 (to 1 decimal). b1 = b0 = Complete the estimated regression equation (to 1 decimal). = b. + x According to this model, what is the change in annual sales ($1000s) for every year of experience (to 1 decimal)? c. Compute the coefficient of determination (to 3 decimals). Note: report r2 between 0 and 1. r2 = What percentage of the variation in annual sales ($1000s) can be explained by the years of experience of the salesperson (to 1 decimal)? % d. A new salesperson joins the team with 8 years of experience. What is the estimated annual sales ($1000s) for the new salesperson (to the nearest whole number)? $
Purchase answer to see full attachment