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?

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.

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

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?

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.

Numerical Analysis Homework Help

Select any dataset that contains more than 300 observations with at least 10 attributes from https://archive.ics.uci.edu or https://www.kaggle.com or any other online free data repository. Perform det

Select any dataset that contains more than 300 observations with at least 10 attributes from https://archive.ics.uci.edu or https://www.kaggle.com or any other online free data repository. Perform detailed analyses on the selected data by using ONE (1) data reduction method and ONE (1) clustering method of your choice. Explain your choices and discuss your results.

 NOTES:

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

• Describe data set information such as number of instances/ features/ attributes/ columns, number of dataset/rows, area/ domain/ field, and/or missing value(s) if any.

 • 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 and plots.

Numerical Analysis Homework Help

In order to complete this assignment, you will need to decide on a theme related to strategic issues in Business leadership that interests you. Then, following the guidance below, search out and analy

In order to complete this assignment, you will need to decide on a theme related to strategic issues in Business leadership that interests you. Then, following the guidance below, search out and analyze one article related to your theme( and at least one review of that article)each week (up to a total of 5 themes) to even out your workload. For the DL paper, first read the material and take good notes. As with any reading, identifying gaps, “holes”, omissions, factual inconsistencies, etc. Since you are asked to read more than one work and compare the gaps, etc. between the two. Second, find and read at least one other review of each work. Deconstruct each review, as well. Remember to make a note of the citation and reference information and incorporate these into your final paper. Then prepare a narrated power point version of your presentation to turn in.

Numerical Analysis Homework Help

i need this answer in 15-20 minutes Solve the following linear programming model graphically: Maximize Z = 3 x1 + 2 x2 Subject to: 2 x1 + 4 x2 ≤ 22 -x1 + 4 x2 ≤ 10 4 x1 – 2 x2 ≤ 14 x1 – 3 x2 ≤ 1

i need this answer in 15-20 minutes

Solve the following linear programming model graphically:

Maximize    Z = 3 x1 + 2 x2Subject to: 

2 x1 + 4 x2 ≤ 22-x1 + 4 x2 ≤ 104 x1 – 2 x2 ≤ 14×1 – 3 x2 ≤ 1×1, x2 ≥ 0

(a)  Solve the Linear programming model graphically, gives all the corner points along with the values of Z and identify which one is optimal. Give reasons.

(b)  Find the value of the slack and surplus variables at the optimal solution only.

Numerical Analysis Homework Help

i need some one to answer these 2 question in 30 minute 1)Prem Lam is establishing an investment portfolio that will include stock and bond funds. She has $1720,000 to invest, and he does not want the

i need some one to answer these 2 question in 30 minute

1)Prem Lam is establishing an investment portfolio that will include stock and bond funds. She has $1720,000 to invest, and he does not want the portfolio to include more than 75% stocks. Prem does not want the portfolio to include less than 45% bonds as well. The average annual return for the stock fund he plans to invest in is 28%, whereas the average annual return for the bond fund is 16%. He further estimates that the most he could lose in the next year in the stock fund is 25%, whereas the most she could lose in the bond fund is 15%. To reduce his risk, he wants to limit his potential maximum losses to $120,000.

Formulate a linear programming model for this problem that will maximize his returns on the portfolio.

2)Dorian Auto manufacturers luxury cars and trucks. The company believes that its most likely customers are high-income women and men. To reach these groups, Dorian Auto has embarked on a ambitious TV advertising campaign and has decided to purchase 1-minute commercial spots on two types of programs; comedy shows and football games. Each comedy commercial is seen by 7 million high income women and 2 million high income men. Each football commercial is seen by 3 million high-income women and 11 million high-income men. A 1-minute comedy ad costs $40,000, and a 1-minute football ad costs $90,000. Dorian would like the commercials to be seen by at least 25 million high-income women and 20 million high-income men.

Use linear programming to determine how Dorian Auto can meet its advertising requirements at minimum cost

Numerical analysis homework help

Katherine D’Ann is planning to finance her college education by selling programs at the football games for State University. There is a fixed cost of $400 for printing these programs, and the variable cost is $3. There is also a $1,000 fee that is paid to the univer-sity for the right to sell these programs. If Katherine was able to sell programs for $5 each, how many would she have to sell in order to break even?
Katherine D’Ann, from Problem 1-18, has become concerned that sales may fall, as the team is on a ter-rible losing streak and attendance has fallen off. In fact, Katherine believes that she will sell only 500 programs for the next game. If it was possible to raise the selling price of the program and still sell 500, what would the price have to be for Katherine to break even by selling 500?
Please include excel breakdown&show the work.