HI, I need paper to summary the main points in the attachment Humanities Assignment Help

1. As described above, you must upload the Real Estate Database into SAS.

2. You must perform the described analysis in Excel and submit the Spreadsheet.

3. You must perform the described analysis in SAS and submit a PDF.

4. You must complete the Word document (answers from 2 and 3 above) and submit.

SAS® Forecasting Project for Critical Thinking

This project utilizes the “Real Estate – Base” database. The purpose is twofold:

• Build critical thinking skills needed to structure data analysis appropriately for effective decision making.
• Analyze available data practically and skillfully in order to build an explanatory regression model.

The Real Estate – Base database includes the following variables for 101 homes (* NOTE: These variables are shown as qualitative variables within the database):

• *Unit# (An assigned database key)
• *Type (H = House, C = Condo/Apartment)
• *Location (1 through 10 – voting district where located)
• *U/S/R (Urban vs. Suburban vs. Rural location)
• Price (The price the house ended up selling for in 2017)
• Sq. Ft. (Heated/Cooled & Attached square footage)
• Lot (Acres) (Acreage of property)
• Garage (Number of attached covered and/or enclosed parking positions)
• BRs (Number of qualified bedrooms)
• Baths (Number of bathrooms – no tub or shower indicated as .5)
• *Pool (No=No Access; HA=Shared Pool; AG=Above Ground; IG=In Ground)
• Age (Age of home in rounded year at end of 2017)

At a high level, here are the steps you are going to perform:

• Download the Excel spreadsheet with the Real Estate Data in it and create the requested Scatterplots. NOTE: It is important that the Dependent Variable (Price) is on the Y-axis and the Independent Variable is on the X-axis. The order of the two columns will dictate that.
• Perform Regression Analysis within Excel to determine how well the prescribed Independent Variables explain changes in the Dependent Variable.
• Upload the Real Estate dataset into SAS Studio.
• Perform a series of Regression Analyses in SAS Studio to find a better set of explanatory variables.
• Answer a critical thinking exercise regarding forecasting and the data set we have.

Here are the steps in detail:

• Create the following charts in Excel using the charting tools and the indicated variables in “Real Estate – Base.xlsx” (Remember, Price is your Dependent Variable)
  • Create a new tab in the spreadsheet called “Scatterplots”. After creating each Scatterplot on the original tab, move it to the Scatterplot tab you created.
  • Create a Scatterplot using the variables Price and Sq. Ft.
  • Create a Scatterplot using the variables Price and Lot (Acres).
  • Create a Scatterplot using the variables Price and Garage.
  • Create a Scatterplot using the variables Price and BRs.
  • Create a Scatterplot using the variables Price and Baths.
  • Create a Scatterplot using the variables Price and Age.
• What sort of relationship do you see between these variables based on the scatterplots?
  • Between Price and Sq. Ft. (Circle)?
  • Between Price and Lot (Circle)?
  • Between Price and Garage (Circle)?
  • Between Price and BRs (Circle)?
  • Between Price and Baths (Circle)?
  • Between Price and Age (Circle)?
• In the Excel spreadsheet provided, using the Data Analysis Add-in, run a regression analysis with Price as the Dependent Variable and Lot, Garage and BRs as the Independent Variables and select to have Excel create a new tab called “Regression Model”. It is recommended that you run individual regressions with each variable alone to see how strong each R² is.
• Provide the following from the “Excel Model”:
  • Coefficient of Determination (R-squared) ___________________
  • Y-Intercept for the Regression Model ___________________
  • Slope value for X1 (Lot) ___________________
  • Slope value for X2 (Garage) ___________________
  • Slope value for X3 (BRs) ___________________
• Do you think we need all three current Independent variables in our Regression model to predict changes in Price (Circle)? Yes No
• Which variable(s) would you remove (Circle)?
• Of the following variables in the spreadsheet, which variable would you select next to add to the model (i.e., you think it would create a stronger prediction of Price)?
• Run a SAS Regression Model on the Real Estate – Base database using Price as the Dependent Variable (Y) and include the original Independent Variables (minus any you removed in step 6) and adding the variable you chose in step 7. Print your model output and turn it in with the assignment. (NOTE: You may have to repeat this exercise until you find a combination of variables that gives you a higher R²).
• Provide the following from the SAS Model:
  • Coefficient of Determination (R-squared ). ________________________
  • Y-Intercept for the Regression Model ________________________
  • Slope value for each of your Independent Variables.
    • Var_______________________ ________________________
    • Var_______________________ ________________________
    • Var_______________________ ________________________
    • Var_______________________ ________________________
    • Var_______________________ ________________________
• Did your SAS model provide a stronger Coefficient of Determination (Circle)? Yes No
• A large real estate company is trying to use similar data plus their own sales data to forecast total sales for the coming year for each of their agents and they have pulled data from their Finance records. They are trying to assemble the best data to build a Regression model.
  • Would it make sense to use the same data as we used above in the SAS model? Why or why not?
  • Recommend two data elements you think they probably have available to help them predict sales for each of their sales people.

No relationship Weak Moderate Strong

No relationship Weak Moderate Strong

No relationship Weak Moderate Strong

No relationship Weak Moderate Strong

No relationship Weak Moderate Strong

No relationship Weak Moderate Strong

Explain: _________________________________________________________________________

_______________________________________________________________________________

_______________________________________________________________________________

Lot Size Garage BRs

Type Location U/S/R Sq. Ft. Baths Pool Age

Critical Thinking Question:

__________________________________________________________________________________

__________________________________________________________________________________

• ______________________________________________
• ______________________________________________

GRADING RUBRIC

Overall Score Possible = 100

Problem Area	Possible Points	Points Awarded
Did the student create the Excel tab for Scatterplots?	2
Did the student create the correct scatterplots and move them to the new tab?	3
Did the student make a selection for each type of relationship?	5
Did the student run Data Analysis on the Excel spreadsheet creating a new tab for the model output?	10
Did the student provide the correct model output values from the spreadsheet in the problem document?	10
Did the student answer Critical Thinking questions 5, 6 and 7?	20
Did the student run a regression model in SAS and provide a print out of the model output?	20
Did the student provide the correct model output values from SAS in the problem document and answer the decision problem (#10)?	10
Did the student complete all parts of the Critical Thinking problem #11?	20
Total Critical Thinking Points	100

n a sunny day, the water in a swimming pool may warm up a degree or two while the concrete around the pool may become too hot to walk on with bare feet. This may seem strange since the water and concrete are being heated by the same source—the sun. This evidence suggests that it takes more heat to raise the temperature of some substances than others, which is true. The amount of heat required to raise the temperature of 1 g of a substance by 1 degree is called thespecific heat capacity or specific heat of that substance. Water, for instance, has a specific heat of 4.18 J/Kg. This value is high in comparison with the specific heats for other materials, such as concrete or metals. In this experiment, you will use a simple calorimeter and your knowledge of the specific heat of water to measure the specific heat of aluminum (Al). 1. Start Virtual ChemLab, select Thermodynamics, and then select Specific Heat of Al from the list of assignments. The lab will open in the Calorimetry laboratory. 2. Click on the Lab Book to open it. Record the mass of Al on the balance. If it is too small to read click on the Balance area to zoom in, record the mass of Al in the data table below, and return to the laboratory. 3. Pick up the Al sample from the balance pan and place the sample in the oven. Click the oven door to close. The oven is set to heat to 200C. 4. The calorimeter has been filled with 100 mL water. The density of water at 25C is 0.998 g/mL. Use the density of the water to determine the mass of water from the volume and record the volume and mass in the data table. Make certain the stirrer is On (you should be able to see the shaft rotating). In the thermometer window, click Save to begin recording data. Allow 20-30 seconds to obtain a baseline temperature of the water. You can observe the temperature in the calorimeter as a function of time using the graph window. 5. Click on the Oven to open it. Drag the hot Al sample from the oven until it snaps into place above the calorimeter and drop it in. Click the thermometer and graph windows to bring them to the front and observe the change in temperature in the graph window until it reaches a constant value and then wait an additional 20-30 seconds. Click Stop in the temperature window. (You can click on the clock on the wall labeled Accelerate to accelerate the time in the laboratory.) A data link icon will appear in the lab book. Click the data link icon and record the temperature before adding the Al and the highest temperature after adding the Al in the data table. (Remember that the water will begin to cool down after reaching the equilibrium temperature.)

Step 1:

Review the Lecture on Academic Summary, paying particular attention to the formatting requirements.

Step 2:

Write an academic summary for the text you want to summarize and respond to in Essay 1.

Make sure to follow the format outlined in the lecture and below:

1. Introduce the text to your reader. Note the title, author, type of text, and what the text is

about. Remember that your reader may not be familiar with the text, so be as specific as

possible. (1-3 sentences)

2. Describe the author’s main idea or argument. Refer to the author by his/her name. Do

not use a direct quote: instead, articulate in your own words what you think the point of

the text is. (1-3 sentences)

3. Explain how the author supports the main idea or argument. Keep an eye out for how the

author organizes and/or divides up the text (are there sub-headings?). Pay attention to

the author’s use of evidence, quotes from experts, examples from history, etc. The author

might also use certain language or literary devices to support an argument. (1-3

sentences)

4. Interpret why you think the author wrote the text. What is the context, or background,

for this topic? Who is the audience? What does the author intend for the audience to take

away from the text?

Note that the summary you write here can go into your Essay 1’s summary paragraph, so you are basically taking out a part of Essay 1 by completing this assignment! With that being said, do your best work!

Visit the Agency website to help address section 1 & 2: Agency name: The Beacon & website https://www.beaconhomeless.org/

Scroll down to the bottom of the home page and select the learn more tab to view the different services offered and programs ( Day Center, Brigid’s Hope, Beacon Law and The Way Home)

SECTION 1: INTRODUCTION

*Briefly introduce your field agency (services provided, client population served, etc)

Client population is Houston’s homeless population in general as well as sub populations tailored to each program but only one target population is needed.

*Describe a client system for your study (demographics, culture, values, social/economic support, health, etc) (Note: Review the information in the “Client System Levels” tab, and make sure this client system is reflective of the system level assigned to you by the Instructor)

INDIVIDUAL client system: This will include one individual who might come to your agency for services. Describe one, hypothetical individual (he/she/they can be based on a real client or case x that your Field Instructor discusses with you). Imagine this client were to receive services at your agency. In terms of problem identification, think about what problem this one individual might be experiencing. Your one, individual client would participate in assessment, intervention, and evaluation.

*Describe your client system strengths and weaknesses

SECTION 2: SCOPE OF PROBLEM

*Discuss the main problem this client system is experiencing (chronic homelessness)

*Describe in which phase of the problem-solving/plan-change process that you discovered this was a problem

Phases of the Problem-Solving Process

Engagement – includes personal and professional preparation for the meeting; introductions and orientation to the process; review and consideration of policy and ethical factors; and activities directed toward understanding the nature of the presenting problem and identifying a preliminary goal.

Assessment – includes activities directed toward more complete and thorough mutual understanding of the nature, extent, severity, and development of the problem and prior attempts at problem-solving within the context of client lives and circumstances.

Intervention – includes the collaborative development of the service plan during the assessment process which comprises of an action plan for implementation by the client-and-worker during the intervention phase.

Evaluation – includes activities directed toward considering the nature, process, and outcomes of the collaborative work toward problem resolution and goal attainment. Also includes a planned process of disengagement through which clients and workers may conclude their work together and say their goodbyes.

*Describe the breadth and depth of the problem and the impact on client system functioning (breadth= what/who is being affected; depth= the severity/magnitude of impact)