Reference no: EM13725721
Problem 1:
1. Plot a scatter chart to examine the relationship between the Year Movie Released and Sales. Include a trend line for this scatter chart. What does the scatter chart indicate about Sales over time for all the movies?
2. Generate a frequency distribution, percent frequency distribution, and histogram for Sales, Use bin sizes of $100 million. Interpret the results. Do any data points appear to be outliers in this distribution?
3. Use the PivotTable to generate crosstabulation for movie type and rating. Determine which combination of type and rating are most represented in the top 50 movie data.
Problem 2:
I. Develop numerical summaries of the data (mean, median, standard deviation, range and the correlation for each pair of variables). Present your results in tabular form.
2. Develop an estimated simple linear regression model that can be used to predict the contributors giving rate, given the graduation rate. Is there a relationship between the two variables? Discuss your findings and explain how you reached your conclusions.
3. Develop an estimated multiple linear regression model that could be used to predict the contributors giving rate, using the graduation rate, percentage of classes offered with fewer than 40 students, and Student to teacher ratio as independent variables. Discuss your findings and explain how you reached your conclusions.
4. Based on the results in parts 2 and 3, do you believe another regression model may be more appropriate? Estimate this model and explain how you reached your conclusion.
5. Results suggest that the relationship between the contributors giving rate and the graduation rate may be nonlinear. Do you agree with this statement? Explain why? If you agree estimate and discuss the new nonlinear model.
6. What conclusions and recommendations can you derive from your analysis? Which schools are achieving a substantial higher contributors giving rate than would be expected? Which schools are achieving a substantial lower contributors giving rate than would be expected?
7. Do you think that other independent variables could be included in the model? Why? Give examples of such independent variables.
Attachment:- problem1.xlsx
Attachment:- problem2.xlsx
|
Aggressive entertainment and gift program
: "Let's face it. Our product is no different from that of 20 other competitors. It sells for the same price and for the same terms. We all give the same service. It really doesn't matter to the buyer which of us gets the order. So the only way we c..
|
|
Unstructured employment interviews
: Discuss some of the reasons why managers continue to use unstructured employment interviews despite the abundant evidence that they are not useful for predicting future job performance.
|
|
What is this regression relationship and how strong is this
: Evaluate the registrar's belief that there is a direct relationship between the number of freshman applications as the tuition increases. What is this regression relationship and how strong is this relationship
|
|
Kurt lewin model for change
: Research Kurt Lewin's model for change. Then, discuss the three-staged de-biasing process (unfreezing, change, and refreezing) and explain the mechanisms that make each of them hard to implement.
|
|
What does the scatter chart indicate about sales
: Plot a scatter chart to examine the relationship between the Year Movie Released and Sales. Include a trend line for this scatter chart. What does the scatter chart indicate about Sales over time for all the movies?
|
|
What are the goals of competitive intelligence
: After watching the video (https://www.youtube.com/watch?v=OTpwUUNepZc&feature=player_embedded) and reviewing this week's readings, What are the goals of competitive intelligence
|
|
Understand the biases of others
: Bazerman and Moore suggest that we should understand the biases of others. Discuss this concept in terms of why it is important for us to understand other peoples' biases. In your discussion, focus on how you might be able to improve your decisio..
|
|
Write an essay on implementing organizational change
: Select one of the following approaches to understanding or implementing organizational change. Summarize this approach and provide an example of how this information could be useful to an organization.
|
|
Concept of analogical reasoning
: Describe the concept of analogical reasoning. Then, considering your last purchase decision, discuss how analogical reasoning could have helped you to improve your decision and increase your satisfaction with the product or service that you purcha..
|