assignment 3

1- only use the sources below, if you do not have them do not take the order.
2- use as simple language as possible

(instructions)
Each student will write a paper for this course building on the basic understanding of the way theology is done. This paper will select a particular current issue that the student believes is in some way related to religious beliefs. The aim of the paper, which is to be 5 pages typed, double spaced, is to explore the way religious beliefs are applied to real issues in order to provide the believer a way of acting in the world. The structure for the paper will follow a pattern which:

Identifies and describes an important current issue giving as much detail about the basic questions that all people face in dealing with an issue as possible (e.g., any of the current issues that have been discussed in class and are the focus of any of our readings such as religious pluralism, the environment or violence).

Asks which basic religious beliefs are connected to and inform a believer’s views on the issue described.

Describes what historical ideas and practices (meaning the range of views Christians have had on any particular belief) from the religious tradition apply in particular to the way the believer forms their views on the issue.

And offers the student’s personal point of view (not what your opinion is of the issue but rather what you think of what the authors have said about Christian belief) on a religious perspective which is defended by applying the fundamental beliefs you have discussed above.

Ample time during the course will be given to explore examples of what the student is asked to do in this paper so that working models should be plentiful to help the student respond to each of these points in their paper. Remember that the focus of the paper is not the issue you have selected but rather the Christian viewpoint you have put together. The paper is due on the date listed in the class schedule of the course syllabus.
(sources)
THE CHRISTIAN BIBLE (Old and New Testaments) ISBN: 0060655275
Chopp, Rebecca and Mark Taylor. Reconstructing Christian Theology ISBN:0800626966
Hanson, Bradley. Introducion to Christian Theology. ISBN:0800629841
Moore, James. Toward A Dialogical Community. ISBN: 0761828362

1
Assignment 3
Due: November 8th (Saturday) end of day
Total points: 100
Instructions
“SAMA provides reliable, up-to-date property assessment valuations – the pillar upon which governments set tax policy and property tax rates.”
You are a data analyst working for Saskatchewan Assessment Management Agency (SAMA). In order to properly assess property tax, municipalities must have an accurate idea of what the market price is for all homes in their respective municipalities. SAMA provides those property assessments.
SAMA uses regression analysis for determining the market prices of all houses. Your boss has asked you to make recommendations on what variables to include in the SAMA regression model used to determine property values for the next assessment period for all homes in Regina.
For this analysis look at how the below variables:
? Building Type
? Built in
? Bathrooms (Total)
? Cooling
? Floor Space
Impacts the housing prices. For your analysis report in a table the summary statistics (mean, median, mode, max, min, sd and the coefficient or variation) for each variables above in addition to the asking price variable.
You are provided with a raw data file from the MLS website.
You may assume:
? The data you have is a simple random sample of housing in Regina
? The asking price is the same as the sold price.
Structure your analysis the same way as below
ISSUE (5pts)
Short one or two sentence explanation of your research.
2
BACKGROUND (5pts)
A short description of the expected result and the economic theory behind it.
A short description of the data you are using (source, quality, sampling method, bias).
ANALYSIS
Access (20pts)
Submit your database
a) Make a query to pull your data from the database with the correct variables call it qryhousing(Lab2.7)
a. Make a new ‘Floor space’ variable that is a number (sqft removed) and call it ‘Floor space_Number’
Excel(20pts)
Submit your excel workbook
a) Link in your query data from access into an excel table (do not copy and paste data – use Lab 2.8 as a guide) (note do not make a pivot table make a table) call this sheet ‘cleaning data’
b) In your cleaning data sheet add additional variables (lab 3.1)
a. Make a new variable called ‘Asking_price_Bin’ that will be used to make histograms have the bin ranges increment by 100,000
b. Make a new variable for ‘Bathrooms(Total)’ with 1,2 and over 3 as data points and call it ‘Bathrooms(Total)_Categorical’
c. Make a categorical variable for the floor space variable
c) Create tables and graphs in an analysis sheet
a. Make a frequency distribution for the asking price
b. Create a summary statistics table for each variable including the (mean, median, mode, max, min, sd and the coefficient or variation)
c. Make a relative frequency distribution for asking price comparing the distributions for different values of (lab3 .2)
i. Building Type
ii. Bathrooms(Total)
iii. Cooling
iv. Floor Space
d. Report the conditional probabilities of
i. (Asking price between 200-300k | >3 Bathrooms)
ii. (Asking price between 200-300k | Air Conditioning)
iii. (Asking price between 300-400k | House)
e. Test the relationships below for dependence/independence
i. (Asking price between 100-200k | >3 Bathrooms)
ii. (Asking price between 200-300k | Air Conditioning)
3
iii. (Asking price between 0-100k | House)
Written(20pts)
Discuss you frequency distributions as well as you summary statistics. What variable would you recommend putting in the regression model.
CONCLUSION (10pts)
Make your recommendation

1
Assignment 3
Due: November 8th (Saturday) end of day
Total points: 100
Instructions
“SAMA provides reliable, up-to-date property assessment valuations – the pillar upon which governments set tax policy and property tax rates.”
You are a data analyst working for Saskatchewan Assessment Management Agency (SAMA). In order to properly assess property tax, municipalities must have an accurate idea of what the market price is for all homes in their respective municipalities. SAMA provides those property assessments.
SAMA uses regression analysis for determining the market prices of all houses. Your boss has asked you to make recommendations on what variables to include in the SAMA regression model used to determine property values for the next assessment period for all homes in Regina.
For this analysis look at how the below variables:
? Building Type
? Built in
? Bathrooms (Total)
? Cooling
? Floor Space
Impacts the housing prices. For your analysis report in a table the summary statistics (mean, median, mode, max, min, sd and the coefficient or variation) for each variables above in addition to the asking price variable.
You are provided with a raw data file from the MLS website.
You may assume:
? The data you have is a simple random sample of housing in Regina
? The asking price is the same as the sold price.
Structure your analysis the same way as below
ISSUE (5pts)
Short one or two sentence explanation of your research.
2
BACKGROUND (5pts)
A short description of the expected result and the economic theory behind it.
A short description of the data you are using (source, quality, sampling method, bias).
ANALYSIS
Access (20pts)
Submit your database
a) Make a query to pull your data from the database with the correct variables call it qryhousing(Lab2.7)
a. Make a new ‘Floor space’ variable that is a number (sqft removed) and call it ‘Floor space_Number’
Excel(20pts)
Submit your excel workbook
a) Link in your query data from access into an excel table (do not copy and paste data – use Lab 2.8 as a guide) (note do not make a pivot table make a table) call this sheet ‘cleaning data’
b) In your cleaning data sheet add additional variables (lab 3.1)
a. Make a new variable called ‘Asking_price_Bin’ that will be used to make histograms have the bin ranges increment by 100,000
b. Make a new variable for ‘Bathrooms(Total)’ with 1,2 and over 3 as data points and call it ‘Bathrooms(Total)_Categorical’
c. Make a categorical variable for the floor space variable
c) Create tables and graphs in an analysis sheet
a. Make a frequency distribution for the asking price
b. Create a summary statistics table for each variable including the (mean, median, mode, max, min, sd and the coefficient or variation)
c. Make a relative frequency distribution for asking price comparing the distributions for different values of (lab3 .2)
i. Building Type
ii. Bathrooms(Total)
iii. Cooling
iv. Floor Space
d. Report the conditional probabilities of
i. (Asking price between 200-300k | >3 Bathrooms)
ii. (Asking price between 200-300k | Air Conditioning)
iii. (Asking price between 300-400k | House)
e. Test the relationships below for dependence/independence
i. (Asking price between 100-200k | >3 Bathrooms)
ii. (Asking price between 200-300k | Air Conditioning)
3
iii. (Asking price between 0-100k | House)
Written(20pts)
Discuss you frequency distributions as well as you summary statistics. What variable would you recommend putting in the regression model.
CONCLUSION (10pts)
Make your recommendation