# need someone to make stats task in excel

Mini Case 1 using Excel: Data Tables for the Walsh borne Extended-Stay Hotel

The weekly price at the Walsh borne Extended-Stay Hotel (renting by the week for business travelers) is \$950. Operating costs average \$20,000 per week, regardless of the number of rooms rented. On a new worksheet in the Midterm Exam workbook, construct a spreadsheet model to determine the profit if 40 rooms are rented. The manager has observed that the number of rooms rented during any given week varies between 32 and 50 (the total number of rooms available).

a. Use a one-way data table to evaluate the profit for this range of unit rentals.

b. Suppose the manager is considering lowering or increasing the weekly price by \$100. How will profit be affected? Create a new two-way data table to account for this change.

Mini-Case 2 using Excel: Regression Analysis at Medex Medical School

A recent ten-year study conducted by a research team at the Medex Medical School assessed how age, systolic blood pressure, and smoking relate to the risk of strokes. (If the blood pressure is 120/90, the systolic blood pressure is the top number). Assume that the data in the Health Data spreadsheet are from a portion of this study. Risk is interpreted as the probability (times 100) that the patient will have a stroke over the next ten-year period. For the smoking variable, define a dummy variable of 1 (indicating a smoker) and 0 (indicating a non-smoker). Complete the following:

a. Create a correlation matrix to assess for correlation and multicollinearity. Comment on this sheet whether multicollinearity exists between the independent variables. Also cite which independent variable is the most correlated to the risk of having a stroke.

b. Develop an estimated multiple linear regression equation that relates risk of a stroke to the person’s age, systolic blood pressure, and whether the person is a smoker. (Assume a linear model, not a curvilinear model, for this mini-case.)

Fähigkeiten: Ingenieurwesen, Excel, Mathematik, SPSS-Statistiken, Statistiken

Über den Arbeitgeber:
( 121 Bewertungen ) Calcutta, India

Projekt-ID: #11802854

## 20 Freelancer bietetn im Durchschnitt ₹521/Stunde für diesen Job an

proffesor1

Hellow, I have 10 years of experience in data analysis; have a university degree in physics and economics. I studied mathematics and statistics at university, therefore, I know these subjects very well. In addition, Mehr

₹2222 INR / Stunde
(12 Bewertungen)
5.4
suyashdhoot

Hi I am a very experienced statistician and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have d Mehr

₹1000 INR / Stunde
(46 Bewertungen)
5.6
isacbogdan

Hello, I am Isac and I have extensive knowledge of statistics as I worked as a statistician for a multinational company for 4 years. I also have experience in academic research with applied statistics and with psyc Mehr

₹1000 INR / Stunde
(15 Bewertungen)
4.8
₹1000 INR / Stunde
(29 Bewertungen)
4.2
TellezMiotta

Hi! My name is Fernando Téllez. I am a senior year student of electrical engineering at Universidad Simón Bolívar (USB), one of the most prestigious universities in my country (Ranked 34° at the QS University Rankings: Mehr

₹277 INR / Stunde
(6 Bewertungen)
3.5
eadishchev

Hi, I have a huge experience both in statistics and in excel. Will be happy to provide you with solutions for your tasks.

₹500 INR / Stunde
(7 Bewertungen)
3.6
evrimdemir0

hi, I can complete this task

₹388 INR / Stunde
(3 Bewertungen)
2.3
martInghia

Hello, my name is Martín Ghia from Argentine. I'm industrial engineer and I have been working using excel for 12 years. Currently I'm working in a large food processor company and start doing projects as freelancer t Mehr

₹300 INR / Stunde
(2 Bewertungen)
1.5
pushar71

HI Keen to work on this project, i have handled lots of P&L reports and activities and have good understanding of accounting principles and data reporting. Please send a sample and i will show you in on hour some Mehr

₹444 INR / Stunde
(2 Bewertungen)
2.0
yassirstats

Hi, I'm an engineer in statistics, an expert in data analysis and regression and i'll happily do this work for you. answer to the questions you mentioned will be properly reported in word file in a professional way, Mehr

₹400 INR / Stunde
(1 Bewertung)
1.1
rahulsarawagi

I have gone through the case and considering my expertise in the subject matter i would like to go ahead with the same. The final output will be delivered as per your time lines.

₹333 INR / Stunde
(0 Bewertungen)
0.0
thinkitltd4

I have read your job description. I have proper experience about many data entry, research, internet research, market research, information research, data collection, data input, MS word, Excel sheet, power point etc.

₹111 INR / Stunde
(0 Bewertungen)
0.0
natiaotarashvili

Hello I work on statistics, I made some excel data for hotel. please see my JPG file. If you like it please contact me. Best regards

₹277 INR / Stunde
(0 Bewertungen)
0.0
fb57bc71657cadc

My principle is sincerely promise and mastery of work and the introduction of the reasons for success

₹111 INR / Stunde
(0 Bewertungen)
0.0
₹277 INR / Stunde
(0 Bewertungen)
0.0
englaysson

I am an Engineer expert in MS Excel, GIS and Artificial Intelligence. I can solve these problems using a friendly spreadsheet with graph visualization.

₹388 INR / Stunde
(0 Bewertungen)
0.0
kabbylinks

Hello.. I am result oriented and highly versatile professional writer with 10+ years of experience. Satisfaction is my top Priority. I have written hundreds of Academic Writing, Technical and Report Writing, Business Mehr

₹555 INR / Stunde
(0 Bewertungen)
0.0
code123red

A proposal has not yet been provided

₹625 INR / Stunde
(0 Bewertungen)
0.0
bnmsba14

Expert in both Excel and Regression Modeling. Would love to get a project to get my score and reputation up!

₹111 INR / Stunde
(0 Bewertungen)
0.0
ssa5613c907a376a

I am fairly proficient with Excel. I use it to keep track of my monthly budget :p For regression analysis part I like using R but I am fine with excel too.

₹277 INR / Stunde
(0 Bewertungen)
0.0