Numerical Analysis Homework Help

he Excel file for this assignment contains a database with information about the tax assessment value assigned to medical office buildings in a city. The following is a list of the variables in the da

he Excel file for this assignment contains a database with information about the tax assessment value assigned to medical office buildings in a city. The following is a list of the variables in the database:

  • FloorArea: square feet of floor space
  • Offices: number of offices in the building
  • Entrances: number of customer entrances
  • Age: age of the building (years)
  • AssessedValue: tax assessment value (thousands of dollars)

Use the data to construct a model that predicts the tax assessment value assigned to medical office buildings with specific characteristics.

  • Construct a scatter plot in Excel with FloorArea as the independent variable and AssessmentValue as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables?
  • Use Excel’s Analysis ToolPak to conduct a regression analysis of FloorArea and AssessmentValue. Is FloorArea a significant predictor of AssessmentValue?
  • Construct a scatter plot in Excel with Age as the independent variable and AssessmentValue as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables?
  • Use Excel’s Analysis ToolPak to conduct a regression analysis of Age and Assessment Value. Is Age a significant predictor of AssessmentValue?

Construct a multiple regression model.

  • Use Excel’s Analysis ToolPak to conduct a regression analysis with AssessmentValue as the dependent variable and FloorArea, Offices, Entrances, and Age as independent variables. What is the overall fit r^2? What is the adjusted r^2?
  • Which predictors are considered significant if we work with α=0.05? Which predictors can be eliminated?
  • What is the final model if we only use FloorArea and Offices as predictors?
  • Suppose our final model is:
  • AssessedValue = 115.9 + 0.26 x FloorArea + 78.34 x Offices
  • What wouldbe the assessed value of a medical office building with a floor area of 3500 sq. ft., 2 offices, that was built 15 years ago? Is this assessed value consistent with what appears in the database?
 
"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"

Numerical Analysis Homework Help

Assignment Content Purpose  This assignment illustrates how data analytics can be used to create strategies for sustainable organizational success while integrating the organization’s mission with so

Assignment Content

Purpose  

This assignment illustrates how data analytics can be used to create strategies for sustainable organizational success while integrating the organization’s mission with societal values. You’ll apply statistical time series modeling techniques to identify patterns and develop time-dependent demand models. You’ll practice organizing and delivering a presentation to senior decision-makers. The PowerPoint presentation includes an audio component in addition to speaker notes.  

Resources: Microsoft Excel, DAT565_v3_Wk6_Data_File

Scenario: A city’s administration isn’t driven by the goal of maximizing revenues or profits but instead looks at improving the quality of life of its residents. Many American cities are confronted with high traffic and congestion. Finding parking spaces, whether in the street or a parking lot, can be time consuming and contribute to congestion. Some cities have rolled out data-driven parking space management to reduce congestion and make traffic more fluid. 

You’re a data analyst working for a mid-size city that has anticipated significant increments in population and car traffic. The city is evaluating whether it makes sense to invest in infrastructure to count and report the number of parking spaces available at the different parking lots downtown. This data would be collected and processed in real-time, feeding an app that motorists can access to find parking space availability in different parking lots throughout the city. 

Instructions: Work with the provided Excel database. This database has the following columns:

  • LotCode: A unique code that identifies the parking lot
  • LotCapacity: A number with the respective parking lot capacity
  • LotOccupancy: A number with the current number of cars in the parking lot
  • TimeStamp: A day/time combination indicating the moment when occupancy was measured
  • Day: The day of the week corresponding to the TimeStamp
  • Insert a new column, OccupancyRate, recording occupancy rate as a percentage with one decimal. For instance, if the current LotOccupancy is 61 and LotCapacity is 577, then the OccupancyRate would be reported as 10.6 (or 10.6%).
  • Using the OccupancyRate and Day columns, construct box plots for each day of the week. You can use Insert > Insert Statistic Chart >Box and Whisker for this purpose. Is the median occupancy rate approximately the same throughout the week? If not, which days have lower median occupancy rates? Which days have higher median occupancy rates? Is this what you expected?
  • Using the OccupancyRate and LotCode columns,construct box plots for each parking lot. You can use Insert > Insert Statistic Chart >Box and Whisker for this purpose. Do all parking lots experience approximately equal occupancy rates?Are some parking lots more frequented than others? Is this what you expected?
  • Select any 2 parking lots. For each one, prepare a scatter plot showing occupancy rate against TimeStamp for the week 11/20/2016 –11/26/2016. Are occupancy rates time dependent? If so, which times seem to experience highest occupancy rates? Is this what you expected?
  • Outline the rationale and goals of the project.
  • Utilize boxplots showing the occupancy rates for each day of the week. Include your interpretation of results.
  • Utilize box plots showing the occupancy rates for each parking lot. Include your interpretation of results.
  • Provide scatter plots showing occupancy rate against time of day of your selected four parking lots. Include your interpretation of results.
  • Make a recommendation about continuing with the implementation of this project.
 
"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"

Numerical Analysis Homework Help

RSCH 600 Term Paper [2 parts] TERM PAPER PART 1: INTRODUCTION, REVIEW OF LITERATURE, PROBLEM STATEMENT, RESEARCH QUESTIONS You need to conduct some research related to your own interests or to

RSCH 600 Term Paper [2 parts]

TERM PAPER PART 1: INTRODUCTION, REVIEW OF LITERATURE, PROBLEM STATEMENT, RESEARCH QUESTIONS

You need to conduct some research related to your own interests or to serve the interests of some organization (employer/client/sponsor). Before you start writing a formal proposal, you (or your employer/client/sponsor) would like to gather some information about the problem as well as understand its importance.

Choose your research topic thoughtfully, as this assignment will be part of your term paper.

HERE ARE THE KEY PARTS OF THIS TERM PAPER (PART 1):

Title of your research

Make it intriguing – (BUT LESS THAN 12 CHARACTERS)

Introduction/Background

Provide a brief description of what the proposed research topic is about, why is it important and how you came to be interested in it.

Literature Review

The purpose of this assignment is to develop skills in finding and analyzing valid literary resources for your research. The review should be written in an integral / synthetic style, and NOT as an annotated bibliography.

This part of your research proposal should be roughly 7-9 pages (excluding cover page and references) and written in paragraphs, report format. All citations and references for this course are to be done in the APA style.

Please note: Use in-text citations to reference all ideas, concepts, text, and data that are not your own. If you make a statement, back it up with a reference!

·         Research a minimum of 15 relevant business-related literature sources (focus on material available in digital format only for this course). Carefully choose your 15 “keepers” that are clearly related to your study. (Note: you might need to find 30 to “keep” only 15).

·         Identify major common themes encountered in the selected literature sources.  For each theme, create its own subsection within the literature review. 

·         For each theme / subsection of the literature review, explain the opinions of the authors and show their similarities, differences, methods of acquisition of data, methods of data analysis and other pertinent information. State how the reviewed research results relate to your proposed study.

·         Identify the gaps in the literature and explain what needs to be done to move forward in your research.

Statement of the Problem

Detail the problem that you are considering. Explain:  

·         How are you defining and delimiting the specific area of the research?

·         What is the gap that will be addressed by this research?

·         What it is that you hope to learn by conducting this research?

·         Discuss the anticipated outcomes and benefits to the researcher, the organization, or society.

Research Questions

Provide focused research questions for your planned research. Also provide a back-up question in case the first one does not pan out. Make sure you address the following questions:

·         What is the scope of your research?

·         Is the scope of your research question reasonable?

please Note: the research question should be limited to 2 questions only 

TERM PAPER PART 2: Statistics in Quantitative Methods

The purpose of the assignment is to develop skills associated with selecting and applying methods for data collection, stationary and time series data analysis and hypothesis testing.

Data collection Identify the sources that will offer the information that you need to answer the research question (journals, books, internet resources, government documents, people, etc). 

1.    What data do you plan to acquire to answer your research question? Why? What kinds of instruments, variables, materials, or sources will you use (i.e. will you use observations, surveys, interviews, case studies, focus groups, experiments, documents, media, data base searches, etc.)? If you plan to use mixed methods, will they be sequential or concurrent? Why?

2.    List the kinds of data/information that you plan to collect (e.g. testimonials, statistics, business/government reports, other research data, audio/video recordings, etc.). Also, consider two or three alternative ways you could gather data/information for this research.

3.    If you plan to use research participants, where will they come from? How will they be sampled? How many participants will you require?

If you are not using research participants, who will you use as the target audience of your data? Who would most benefit from your research, and why?

4.    What ethical issues will your research project present? What biases might you bring to the research and how will you address that bias?

Analysis of stationary data

1.    What method will you choose to analyze the stationary data that you plan to collect?

2.    Has this method of data analysis been applied in similar situations by other authors?  Include references and illustrations from the literature to show the advantages and disadvantages of the method.

3.    Attach a worked-out example of application of the method using simulated or previously published data and explain it.

4.    How will you validate your findings/conclusions?

Testing hypotheses

1.    State your hypotheses.

2.    Explain how to test your hypotheses and justify the choice. 

3.    Have similar hypotheses been tested by other authors?  Include references and illustrations from the literature. Attach a worked-out example of hypothesis testing using simulated or previously published data. 

4.    How will you validate your findings/conclusions?

Analysis and forecasting of time series

1.    Define the time series data you plan to gather related to your topic.

2.    What method will you choose to analyze and forecast the time series data that you plan to collect?

3.    Have these methods of data analysis and forecasting been applied in similar situations by other authors?  Include references and illustrations from the literature to show their advantages and disadvantages.

4.    Attach a worked-out example of analysis and forecasting using simulated or previously published data and explain it. 

5.    How will you validate your findings/conclusions?

 
"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"

Numerical Analysis Homework Help

USING SPSS and the data attached below, ANSWER THE FOLLOWING QUESTION. Questions 1-2 Download the attached gss.sav (data from general social survey). Using SPSS to conduct t-tests to answer the fol

USING SPSS and the data attached below, ANSWER THE FOLLOWING QUESTION. 

Questions 1-2

Download the attached gss.sav (data from general social survey). Using SPSS to conduct t-tests to answer the following questions:

  1. Do internet users on average spend 4.5 hours per week on e-mail (variable: emailhrs)?

a.     List the null hypothesis and the alternative hypothesis.

b.     Use SPSS to run a one-sample t-test and include your SPSS outputs with your answer.

c.     What are the t statistics and p-value of the t-test respectively, according to (b)?

d.     Draw your conclusion on whether or not the null hypothesis in (a) should be rejected (use a 95% significance level), based on (c).

2.     Do females and males (variable name: sex) on average spend same hours on e-mail (variable name: emailhrs)?

  1. List the null hypothesis and alternative hypothesis.
  2. To test the hypothesis, should you use an independent-sample t-test or a paired-sample t-test?
  3. Use SPSS to conduct the test and include your SPSS outputs with your answer.
  4. What are the t statistics and p-value of the t-test respectively, according to (c)?
  5. Draw your conclusion on whether or not the null hypothesis should be rejected, based on the t-test result.

Question 3.

Using the attached dataset World_updated.sav. Two of the variables in this file (rgdp86 and rgdp88) measure real Gross Domestic Product (GDP) per capita in 1986 and 1988 respectively. Please conduct the appropriate t-test to answer the following question: “Is there statistically significant evidence that per capita GDP in 1988 is different from that of 1986?

Please show your results and reasoning to justify your answer by answering the following questions..

  1. List the null hypothesis and alternative hypothesis.
  2. To test the hypothesis, should you use an independent-sample t-test or paired-sample t-test?
  3. Show your SPSS outputs.

d.     What are the t statistics and p-value of the t-test respectively, according to (b)?

  1. Draw your conclusion on whether or not the null hypothesis in (a) should be rejected (use a 95% significance level), based on the t-test result.

Question 4.

It is believed that, the average numbers of hours spent studying per day (HOURS) during undergraduate education should have a positive linear relationship with the starting salary (SALARY, measured in thousands of dollars per month) after graduation. Given below is the Excel output from regressing starting salary on number of hours spent studying per day for a sample of 51 students.    

Note: The format of the regression results has been purposely changed to be different from SPSS outputs; some of the numbers in the output are purposely erased

USING THE TABLE IN THE DOCUMENT .

11) Referring to the table, the estimated average change in salary (in thousands of dollars) as a result of spending an extra hour per day studying is

A) -1.8940

B) 0.7845

C) 0.9795

D) 335.04733

12) Referring to the table, the value of the measured t-test statistic to test whether average SALARY depends linearly on HOURS is

A) -4.7134

B) -1.8940

C) 0.9795

D) 13.3561

 
"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"

Numerical Analysis Homework Help

In preparation for writing your report to senior management next week, conduct the following descriptive statistics analyses with Excel. Answer the questions below in your Excel sheet or in a separate

In preparation for writing your report to senior management next week, conduct the following descriptive statistics analyses with Excel. Answer the questions below in your Excel sheet or in a separate Word document:

  • Insert a new column in the database that corresponds to “Annual Sales.” Annual Sales is the result of multiplying a restaurant’s “SqFt.” by “Sales/SqFt.”
  • Calculate the mean, standard deviation, skew, 5-number summary, and interquartile range (IQR) for each of the variables.
  • Create a box-plot for the “Annual Sales” variable. Does it look symmetric? Would you prefer the IQR instead of the standard deviation to describe this variable’s dispersion? Why?
  • Create a histogram for the “Sales/SqFt” variable. Is the distribution symmetric? If not, what is the skew? Are there any outliers? If so, which one(s)? What is the “SqFt” area of the outlier(s)? Is the outlier(s) smaller or larger than the average restaurant in the database? What can you conclude from this observation?
  • What measure of central tendency is more appropriate to describe “Sales/SqFt”? Why?
 
"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"

Numerical Analysis Homework Help

Select any CATEGORICAL dataset that contains at least 150 observations with THREE (3) attributes from any reliable source. Choose any THREE (3) of the following classification methods i. Logistic Reg

Select any CATEGORICAL dataset that contains at least 150 observations with THREE (3) attributes from any reliable source. Choose any THREE (3) of the following classification methods

 i. Logistic Regression (LR),

 ii. Naïve Bayes (NB), 

iii. Linear Discriminant Analysis (LDA), 

iv. K Nearest Neighbors (KNN), 

v. Support Vector Machines (SVM),

 to perform detailed analyses of the selected dataset. Use the first 70% of the data to train the model and the remaining 30% to test the accuracy of the model. Explain your choices of attributes and discuss your results. NOTES: 

• The link to the selected dataset should be provided and the dataset should NOT have been used in the lectures or labs of the course. 

• Any preprocessing method (e.g. removal or filling of empty cells) performed on the original data needs to be fully described and shown. 

• Your analyses shall include the descriptions of your Python codes or any other software outputs to support the analyses.

 
"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"