Reference no: EM13922237
Regression Analysis
Project #1 - Simple Linear Regression
Data: SLR.xls
In an effort to control costs associated inventory management, a study was conducted on the relationship between sales (X, in billions of US dollars) and inventory levels (Y, in billions of US dollars), with a random sample of size 20. You are assigned to develop a simple linear regression model and report the results.
Assignment:
1. Compute the descriptive statistics for both Y and X, including (but not limited to):
n, mean, median, std, min and max.
2. Show the scatterplot between Y and X. Is a linear model appropriate for the data?
3. Compute the Pearson and Spearman correlations between Y and X and test the null hypothesis of ρ = 0.
4. Suppose the regression model is Y = β0 + β1 X + e, fit the model to the SLR data. Show the regression equation and interpret the meaning of the two coefficients.
5. What is the R2 of the model? What is the meaning of the R2.
6. Are both coefficients significant? Interpret the 95% CI for the two coefficients.
7. What is the predicted value of Y if X = 250 and 300.
|
Ethical decision making
: What strategies can you adopt to improve your ethical decision making in the future?
|
|
Group case study-winter park hotel
: Donna Shader, manager of the Winter Park Hotel, is considering how to restructure the front desk to reach an optimum level of staff efficiency and guest service. At present, the hotel has five clerks on duty, each with a separate waiting line, du..
|
|
Depreciation expense would be reported
: XYZ company uses the activity (units-of-production) method to depreciate long-term assets. The company owns a truck that cost $48,000. The truck is estimated to have a salvage value of $4,000 abd a useful life of 200,000 miles. How much depreciation ..
|
|
Prepare a master schedule for given this information
: Prepare a master schedule like that shown in Figure 11.11 given this information: The forecast for each week of an eight-week schedule is 50 units.
|
|
Regression analysis-simple linear regression
: In an effort to control costs associated inventory management, a study was conducted on the relationship between sales (X, in billions of US dollars) and inventory levels (Y, in billions of US dollars), with a random sample of size 20. You are ass..
|
|
Judgment of management
: The availability of information for both the cost and the potential cost driver.A cause-and-effect relationship between the cost driver and the cost.Judgment of management.
|
|
Distributor current ordering model
: The ordering cost is $100.00 per order. The average holding cost per unit per year is $2.50. The distributor has traditionally ordered 250 units each time they placed an order. Based upon using the distributor's current ordering model:
|
|
Correlation between the paper message and current events
: If you were living during this time, what would your response be to the paper's message? What is the correlation between the paper's message and current events
|
|
Relevant costs can include direct and indirect costs
: The allocation base determines whether a cost is classified as direct or indirect.The same cost cannot be classified as both direct and indirect.Relevant costs can include direct and indirect costs.
|