Respond to the following in a minimum of 175 words:Models help us describe and summarize relationships between variables. Understanding how process variables relate to each other helps businesses predict and improve performance. For example, a marketing manager might be interested in modeling the relationship between advertisement expenditures and sales revenues.Consider the dataset below and respond to the questions that follow:Advertisement ($'000) Sales ($'000)1068 44891026 5611767 3290885 41131156 48831146 5425892 4414938 5506769 3346677 36731184 65421009 5088Construct a scatter plot with this data.Do you observe a relationship between both variables?Use Excel to fit a linear regression line to the data. What is the fitted regression model? (Hint: You can follow the steps outlined on page 497 of the textbook.)What is the slope? What does the slope tell us?Is the slope significant?What is the intercept? Is it meaningful?What is the value of the regression coefficient,r? What is the value of the coefficient of determination, r^2? What does r^2 tell us?Use the model to predict sales and the business spends $950,000 in advertisement. Does the model underestimate or overestimates ales?

Election TheoryApportionment ProjectWhile visiting the planet Mars, scientists discovered a small, isolated region consisting of 45,000 aliens! In order to establish government, U.S. politicians began to divide the region into 10 different states with a total of 30 representatives (not 30 each!). Your duty is to determine how many representatives each state should be apportioned. You will support your decisions from research on apportionment and the U.S. election process.Part a: Research and report on the effects of apportionment on the presidency. 1.How does the power of the Senate compare to the power of the House of Representatives?2.Does the number of representatives per state fluctuate with the population of each election year? 3.Which method of apportionment benefits which kind of state (small or large)? 4. Has the apportionment method ever made a difference in who was elected for president? The research paper must be one page typed. A reference page must be attached.Part b: Create a Timeline that displays the changes and controversies throughout history. Be creative and original. The following questions should be addressed on your timeline: 1.Why and when has the apportionment method been changed? 2. Why has the size of the House been changed? 3. Did paradoxes occur with any methods? Explain.4. What method is currently being used?Part c: Develop an excel spreadsheet to do each of the four apportionment methods for the 10 states. The spreadsheet must contain formulas for: Standard Divisor, Quota, Upper quota, Lower quota, each Initial Apportionment, Arithmetic mean, Geometric mean and each Critical Divisor as needed. Also include a statement about which method you will use to determine the apportionment.You may work with a partner, but your papers and spreadsheet must be done individually. IDENCTIAL PAPERS OR EXCEL FILES will not be graded!Research Paper15One page typed10Reference5Timeline (2 pts for each)10Excel30Accuracy8Neatness & Organization10Use of formula12Submitted draft 3 days before the due date5Total Points60Please NO PlagiarismPlease use MLA style and intext citation

I have the answer for this case but I need it to be business reportI need to make 6 different reports for this case for me and 5 of my friends.It have to be totally different we are in the same class with the same teacherI attached the data set and I attached the answers you can useI need a business report not just answer the questions:The business report has:1- Introduction / summary2- Result / finding/ analysis3- Conclusion2. Refer to the Baseball 2012 data, which report information on the 30 Major League Baseball teams for the 2012 season. Let the number of games won be the dependent variable and the following variables be independent variables: team batting average, number of stolen bases, number of errors committed, team ERA, number of home runs, and whether the team plays in the American or the National League.a. Use a statistical software package to determine the multiple regression equation. Discuss each of the variables. For example, are you surprised that the regression coefficient for ERA is negative? Is the number of wins affected by whether the team plays in the National or the American League?b. Find the coefficient of determination for this set of independent variables.c. Develop a correlation matrix. Which independent variables have strong or weak correlations with the dependent variable? Do you see any problems with multicollinearity?d. Conduct a global test on the set of independent variables. Interpret.e. Conduct a test of hypothesis on each of the independent variables. Would you consider deleting any of the variables? If so, which ones?f. Rerun the analysis until only significant regression coefficients remain in the analysis. Identify these variables.g. Develop a histogram or a stem-and-leaf display of the residuals from the final regression equation developed in part (f). Is it reasonable to conclude that the normality assumption has been met?h. Plot the residuals against the fitted values from the final regression equation developed in part (f). Plot the residuals on the vertical axis and the fitted values on the horizontal axis.