Our Services

Get 15% Discount on your First Order

A cost estimator for a construction company has collected the

November 24, 2021

A cost estimator for a construction company has collected the data found in the source file Estimation.xlsx describing the total cost (Y) of 97 difference projects and the following 3 independent variables thought to exert relevant influence on the total cost: total units of work required (X1), contracted units of work per day (X2), and city/location of work (X3). The cost estimator would like to develop a regression model to predict the total cost of a project as a function of these 3 independent variables.

a. Prepare two scatter plots showing the relationship between the total cost of the projects and each of the two independent variables (X1, and X2). What sort of relationship does each plot suggest? After data analysis, you can find any cell in Excel to write down your interpretation.

b. Suppose the estimator wants to use the total units of work required (X1), contracted units of work per day (X2), and city/location of work (X3) as the independent variables to predict total cost. What should be the regression function between Y and X1, X2, and X3? What is the adjusted R-squared value of this model? What conclusions can you make? (Note that X3 is a dummy variable. You should process it into different categories as I showed you in the class lecture. You should expand X3 into Location1, Location 2, …. Location 5 to differentiate the six locations.) After data analysis, you can find any cell in Excel to write down your interpretation.

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

APPLYING EPIDEMIOLOGY TO PROGRAM DESIGN FOR CHRONIC DISEASE This file is too large to display.View in new window

Subject: ITS-834: Emerging Threats & Countermeasures Reading Resources: Satapathy and

Subject: ITS-834: Emerging Threats & Countermeasures Reading Resources: Satapathy and L. M. J. Livingston. (2016). “A Comprehensive Survey of Security Issues and Defense Framework for VoIP Cloud,” in Indian Journal of Science and Technology, 9(6). https://doi.org/10.17485/ijst/2016/v9i6/81980 D. B. Rawat, 2019. “Fusion of Software Defined Networking, Edge Computing, and Blockchain Technology

Visit one of the following newspapers’ websites: USA Today, New

Visit one of the following newspapers’ websites: USA Today, New York Times, Wall Street Journal, or Washington Post. Select an article that uses statistical data related to a current event, your major, your current field, or your future career goal. The chosen article must have been published after the

1. What can you tell about the US economy based

1. What can you tell about the US economy based on Chair Powell’s press conference (GDP, economic growth, unemployment, inflation)? 2. The Fed’s dual mandate is to promote maximum employment and keep prices stable. Please first explain how the Fed used its monetary policy tools (federal funds target rate, discount

How effective is cognitive behavioral

Description Annotated Bibliography Assignment Overview: The purpose of this assignment is to give you practice conducting a literature search using searchable databases (e.g., PsycINFO, MEDLINE, Google Scholar) and to learn how to create an annotated bibliography. Annotated bibliographies are extended reference lists for a research topic that includes a brief

Week 4 Questions to Answer 1. Facts and Fables About

Week 4 Questions to Answer 1. Facts and Fables About Suicide Indicate with a T or F whether each of the following statements is true or false. _____ 1. Suicide is an inherited trait. _____ 2. Gunshot wounds are the leading cause of death among suicide victims. _____ 3. Most people give clues and

How can rehabilitation professionals adapt their approaches to address the multifaceted challenges posed by amnesia and promote successful outcomes for

How can rehabilitation professionals adapt their approaches to address the multifaceted challenges posed by amnesia and promote successful outcomes for individuals undergoing rehabilitation? This question prompts exploration into the specific strategies, interventions, and considerations that rehabilitation professionals can employ when working with individuals experiencing amnesia. It encourages examination of the

Proposing a mental health education or promotion program on any

Proposing a mental health education or promotion program on any topic of interest in mental health. Students will pretend to present the information to the executive committee of any local or national organization providing mental health services. You can select any population and disorder You can select any population and

voices of reason

Read the article and answer the following questions To access the article and questions please do the following steps: Go to google Type in cuny portal – its the first link Scroll down to SOC 345 Sociology of mental illness – click that Then click content scroll down to 2/14

Discuss gun violence and gun regulations. What are the biggest

Discuss gun violence and gun regulations. What are the biggest challenges in the opioid epidemic? Analyze the security, public health, and regulation debates. Analyze bioterrorism and its threat to national security. Explain the major security challenges related to drug trafficking, gangs, and organized crime. Discuss nuclear and chemical weapons and

Week 4 Assignment (Harris, 2021): Watch: 1. “How to Increase

Week 4 Assignment (Harris, 2021): Watch: 1. “How to Increase Your Potential With a 30-day Goal Framework” YouTube video: https://www.youtube.com/watch?v=tz24KHcwpxI 2. “Setting SMART goals” https://www.youtube.com/watch?v=vKMrWsjUOZQ Week 4 Assignment Part I: For Part I create a 1 – 2-page document that contains answers to the following critical thinking questions: 1. My

For this assignment, you will select one Mathematical Thinking and

For this assignment, you will select one Mathematical Thinking and Reasoning Standards and to explore deeper. Explain the importance of this standard and what it looks like in planning and delivery. Standard: Why is this standard important? What does it “look like” to foster mathematical thinking as you plan and then delivery

Mapping Process Groups and Knowledge Areas

Address each of the Project Management Areas of Knowledge, the process groups that use these areas of knowledge, and how the process groups interact with the knowledge area processes. Use table 3-1, Project Management Process Groups and Knowledge Areas Mapping (PMBOK Guide in section 3.9 Role of the Knowledge Areas),

HSA5100CBE Section 01CBE Causes and Consequences of Events in Healthcare Nursing Assignment Help

Competency Assess the causes and consequences of historical events on the U.S. healthcare system. Scenario You are the Director of Education in your healthcare organization. Your organization is a teaching hospital, and you are responsible for presenting information to new employees and volunteers during their orientation, many of whom are

Create a Computer Network The networking team will work on

Create a Computer Network The networking team will work on the network design for the main photography company and the small studio location. The photography company will anticipate the possibility of more locations as well as more requests for photography events. The photography company needs a networked tracking system to

For this assignment you need to review a video lecture

For this assignment you need to review a video lecture (please print the slides from the FX rate presentation Download presentation to follow along) that explains how to do currency conversions. Once you finish looking over at the presentation, then do the practice exercises Download practice exercises and look

Approach to Enterprise Risk Management

Based on your knowledge of the NIST RMF three-tiered approach to Enterprise Risk Management, address the following: Describe the potential impact of the NIST RMF three-tiered approach to ERM on an organization’s compliance with federal cybersecurity laws and regulations. How are third party systems assessed via the RMF? Include in

Directions are included in the file below Share your completed research proposal in the format of a verbal presentation with your classmates. Create

Directions are included in the file below Share your completed research proposal in the format of a verbal presentation with your classmates. Create a PowerPoint, Prezi, Google Slide, etc. that includes each major point of your presentation and use it as a presentation template.The proposal PowerPoint and presentation must include