A cost estimator for a construction company has collected the

  

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

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Do you think the survey results were accurate overall? Why

  Do you think the survey results were accurate overall? Why or why not. What specific survey assessment and result did you think was most insightful and/or surprised you and why? Did the survey outcomes match to your desired healthcare profession or professions? Why or why not? Which healthcare profession

With ToysRUs closing having for closure for most of the

With ToysRUs closing having for closure for most of the location through the US, many toy companies are facing the same thing. Struggling to keep up with technology and keep interest along with the draw back still being felt from COVID-19. Major innovations to help the market were being tested

Prepare and post an approximately 500-word response to a contemporary

Prepare and post an approximately 500-word response to a contemporary case of your choosing. Identify a current situation, case, disclosure problem, success or failure story, advertising/PR case that relates to/resonates with social responsibility and ethics. Briefly summarize the issue, analyze it, and propose a solution/additional ideas. For full credit, please include

Contemporary Issues in E-Sports – Project In this assignment, you

  Contemporary Issues in E-Sports – Project In this assignment, you will use what you have learned to create a Venn diagram to compare and contrast E-sports to video games and traditional sports. Each category in the triple Venn diagram should have at least three descriptions listed. After creating the

The purpose of this assessment is to produce a marketing

The purpose of this assessment is to produce a marketing audit that would support a   marketing plan. The audit should be produced for a company (or business unit) of your choice  in one sector from; mobile network providers, fashion clothing, automotive or charity and should focus on Thailand only. 

Health & Medical Question Nursing Assignment Help

Topic:  Characterize the manifestations of hypothyroidism and hyperthyroidism For this assignment, you will produce a 4–7 minute powerpoint presentation on your chosen topic. In your presentation, include the following: Include at least one type of visual aid in your presentation, such as PowerPoint slides, diagrams, white board use, etc. You

Rather than simply resigning themselves to passivity or concluding

Throughout this unit, we’ve examined the nature of post-truthness: what defines it, where it comes/came from, and even how we might respond to it. But, of course, this is a phenomenon that you are living through, not just one that you’re reading about. With that being the case, in your

READ THESE INSTRUCTION FIRST The instructions ask you to critique

   READ THESE INSTRUCTION FIRST The instructions ask you to critique an argument. Critiquing an argument means the following. The focus should not be on whether the conclusion of the argument is correct. Rather, the focus should be on whether the reasons given in the argument are correct and whether

For this assignment, you read the article written by Buzi,

For this assignment, you read the article written by Buzi, Smith, and Weinman (2014) located under your weekly resources. These authors used a chi-square analysis to analyze the data from their research study.    Now, make  a summary of the research, including background information on the topic, the main hypotheses,

After completing this week’s labs, reflect on what you learned

  After completing this week’s labs, reflect on what you learned and respond to the following questions in 1 to 2 pages: Reflect on your experience of performing the simulated attacks. What insights did you gain about the attacks and about security from working on these exercises?  What are the

Instructions Assume that you want to create a linked list

Instructions Assume that you want to create a linked list structure for ‘item’s. You are given struct item { string data; item *next; item(string x, item* t) { data = X; next = t: 7 }: In our implementations we used first and last pointers to keep first items and

What is the difference between an internal and external stakeholder?

What is the difference between an internal and external stakeholder? What is the difference between key and secondary? What three tasks comprise the “define scope” process? Why is scope definition important? What are two common causes of scope creep? What is the difference between an activity and a work package?

Read “Narrative Techniques” in this week’s readings to learn techniques

 Read “Narrative Techniques” in this week’s readings to learn techniques and strategies writers use to create a vibrant scene. Then read and annotate the student sample narrative below for all of the narrative techniques.  Annotating a text is a vital literate practice for critical reading as it helps you achieve a deeper,

Influenza

Description Topic: Clinical effectiveness of influenza vaccination in patients with rheumatoid arthritis The style should Harvard Style, Citation IEEE, including an Abstract for the research paper(It should be Descriptive Abstract). Perfect section titles are needed; introduction, discussion, methods, Systematic reviews, meta-analysis, results and conclusion are a MUST. Also graphs, tables

magz64 only

A.  Find an organization related to your health care discipline and identify the mission and vision statement. Based on your experiences as a member of the health care team, explain how the values of the organization are or are not reflected in these statements. B.  Find an organization related to