This requires to use QM again. Hope you can help.Use Excel to answer all of the following questions. Label all output accordingly.3-1. A sample of 20 automobiles was taken, and the miles per gallon, MPG, horsepower, and total weight were recorded.Please see attached excel documentYou may assume X1 = HorsPwr, and X2 = Weight. Or you may define using different variables, but be consistent.(a). Develop a linear regression model to predict MPG, using horsepower as the only independent variable. Develop another model with weight as the independent variable. Which of the two models is better? Why? Make sure you appropriately label all Excel outputs.(b). Using the same data given, develop multiple regression model. How does this compare with each of the models in (a)? Just all the relevant information to support your responses.(c).(i) Use just the multiple regression model you developed in (b) to predict MPG if HrsPwr is set at 150 and Weight is 4400. (ii) Next use the regression models for HrsPwr and Weight separately (independently) for HrsPwr= 150 and Weight= 4400 and predict MPG.(iii). Based on you analyses above c (i & ii), and information gathered from a & b, which forecast do you think would be more accurate/realistic and why?3-2.(a). ABC company records during the past six weeks indicate the number of jobs requests:WEEK123456Requests (Actual)464038424445Required: Predict the number of requests for Week 7 using each of the following methods:iA four-period moving average.ii. Exponential smoothing with a = .40. Forecast for Week 1 was 50.2. (b). Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 monthsCompute MAD and MSE {sum of squared errors divided by (n-1)} for each forecast. Does either forecast seem superior? Explain.The forecasts and actual sales are as follows:MonthSALES (ACTUAL)FORECAST IFORECAST II17807707782789785790379479079247807847855778770774677276877077657617598775771775978678479110790788788Please use the QM add in when answering questions for each and explain how the answer was computed.

Click the link above to submit your assignment.Students, please view the "Submit a Clickable Rubric Assignment" in the Student Center. Instructors, training on how to grade is within the Instructor Center. Assignment 2: International Crime Witness, Part 1Due Week 6 and worth 250 pointsUse the Internet to research criminal proceedings in one (1) of the six (6) model countries from the textbook. Imagine you are traveling abroad in your chosen country when you witness a local national committing a violent assault. The criminal is arrested and charged by the police.Upon returning to the United States, a professor in one of your criminal justice classes asks you to complete a written report on your experience.Write a three to five (3-5) page paper in which you:Determine the pertinent demographic, social, political, and economic factors about your chosen country.Examine the manner in which your chosen country’s criminal code would likely view the crime you witnessed. Provide a rationale for the response.Choose two (2) individual rights that the United States grants criminal suspects, such as search and seizure, right to counsel, etc., and analyze the country’s perspective on each right. Provide support for the analysis.Investigate the manner in which the police in your chosen country would likely treat the defendant. Provide justification for the response.Classify the fundamental similarities and differences between the police culture in your chosen country compared to the United States.Use at least four (4) quality references. Note: Wikipedia and other Websites do not qualify as academic resources.Your assignment must follow these formatting requirements:Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.The specific course learning outcomes associated with this assignment are:Compare and contrast American perspectives on criminal law with those of other countries.Evaluate the nature of comparative policing and global law enforcement cooperation.Analyze the role of procedural law in the four (4) major legal traditions.Use technology and information resources to research comparative perspectives in criminal justice.Write clearly and concisely about criminal justice topics using proper writing mechanics and APA style conventions. Click here to view the grading rubric for this assignment.