Complete the following questions. In addition to answering the items below, you must submit an analysis of the assignment. Analyze the specific outcomes and write an analysis directed toward the management team at Smart Company describing what the numbers mean and how they relate to the business. Submit journal entries in an Excel file and written segments in an MS Word document. For written answers, please make sure your responses are well-written, formatted per CSU-Global Guide to Writing and APA and have proper citations, where applicable. Smart Company is preparing its financial statements for the year ended June 30, 2017. The financial statements are complete except for the statement of cash flows. You have been asked to prepare a statement of cash flows for the year ended June 30, 2017. Download the excel spreadsheet found in the link below. Required: Prepare a spreadsheet to support a statement of cash flows for the year ended June 30, 2017. In the tab named ‘Journal Entries’, show in journal entry form, the entries that would be made in preparation of the statement of cash flows. Prepare Smart Company’s statement of cash flows for the year ended June 30, 2017. Prepare the statement of cash flows using the indirect method. Note: For full credit, you must prepare the statement of cash flow in good form with all necessary disclosures, including disclosures about noncash financing and investing activities. Account Balances June 30, 2016 June 30, 2017 Debits Cash $ 361,700 $ 880,550 Accounts Receivable 100,000 125,000 Marketable Securities (at cost) 11,700 13,000 Allowance for Change in Value 1,500 1,800 Construction in Process 168,750 405,000 Prepaid Expenses 45,000 10,000 Investments (long-term) - 13,500 Leased Equipment - 20,000 Building 30,000 - Deferred tax asset 5,375 2,200 Land 10,500 10,500 Discount on Bonds Payable - 1,305 Totals 734,525 1,482,855 Credits Allowance for doubtful accounts $ 6,000 $ 4,500 Accounts Payable 87,500 210,000 Deferred tax liability 1,000 3,300 Income Taxes Payable 3,500 9,000 Note Payable (long-term) 3,500 - Accumulated Depreciation on Building 2,500 - Accumulated Depreciation on Leased Asset - 3,000 Lease obligation - 18,000 Interest payable on lease obligation - 1,800 Interest payable (Bonds) - 1,800 Bonds payable - 45,000 Billings on contruction in process 150,000 325,000 Pension liability 150,000 400,000 Convertible preferred stock, $100 par 9,000 - Common Stock, $10 par 14,000 24,500 Additional Paid-in Capital 8,700 13,700 Unrealized Increase in Value of Marketable Securities 1,500 1,800 Retained Earnings 297,325 421,455 Totals 734,525 1,482,855 Additional information: a. Dividends declared and paid totaled $650. b. 300 shares of common stock (at par) were issued for cash. c. On July 1, 2016, convertible preferred stock that had originally been issued at par value were converted into 500 shares of common stock. The book value method was used to account for the conversion. d. The long-term note payable was paid by issuing 250 shares of common stock at the beginning of the fiscal year. e. Short-term marketable securities were purchased at a cost of $1,300. The portfolio was increased by $300 to a $14,800 fair value at year-end by adjusting the related allowance account. f. During the year, a 30% interest in Ricochet Co. was purchased as an investment for $9,500. Ricochet reported $20,000 in net income for the year and paid dividends of $2,000 to Smart. g. $5,000 of accounts receivable were written off as uncollectible during the year. h. Smart’s inventory consists of Construction-in-Process in excess of the Billings on Construction-in-Process account balance. i. A building was destroyed by fire during the year and insurance proceeds of $26,000 were collected. j. The 12% bonds payable were issued on February 28, 2017, at 97. They mature on February 28, 2027. The company uses the straight-line method to amortize bond premiums and discounts. k. Smart recorded pension expense of $350,000 for the year. l. A lease agreement was signed on July 1st, 2016 for the use of equipment worth $20,000. The company determined that the transaction should be recorded as a capital lease.

Use Python 3.8:

Problem Description

Many recipes tend to be rather small, producing the fewest number of servings that are really possible with the included ingredients. Sometimes one will want to be able to scale those recipes upwards for serving larger groups.

This program's task is to determine how much of each ingredient in a recipe will be required for a target party size. The first inputs to the program will be the recipe itself.

Here is an example recipe that comes from the story "Chitty Chitty Bang Bang", written by Ian Fleming, who is much better known for introducing the world to James Bond:

This is a recipe scaler for serving large crowds!

Enter one ingredient per line, with a numeric value first.
Indicate the end of input with an empty line.
4 tbsp cocoa
1/4 pound butter
2 tsp corn syrup
1 can evaporated milk
1 tsp water

Here is the recipe that has been recorded
 4    tbsp     cocoa
 1/4  pound    butter
 2    tsp      corn syrup
 1    can      evaporated milk
 1    tsp      water

How many does this recipe serve? 16
How many people must be served? 25
Multiplying the recipe by 2

 8    tbsp     cocoa
 2/4  pound    butter
 4    tsp      corn syrup
 2    can      evaporated milk
 2    tsp      water

Serves 32

NOTE: The recipe rounds upwards, since it is usually not practical to obtain fractional cans or fractional eggs, etc.

Your program must obtain a complete recipe (not necessarily this one), echo it with good formatting, and then scale it up as shown above.

Program Hints:

Attractive user-friendly output is rather straightforward, with the help of Python's string formatting features. User-friendly input is a little trickier, but the split function from Unit 2 can be very helpful:

First hint:

The name of an ingredient might be more than one word. This will place all of the extra words into a single string variable 'item':

quant, unit, item = line.split(' ',2)      # pull off at most 2 words from the front

Second hint:

Sometimes the measure will be fractional. We can recognize that if the number contains a slash.

if '/' in quant: 
    numer, denom = quant.split('/')        # get the parts of the fraction

The rest is left up to the student -- since this is a string operation and this fraction represents a number.

Other Guidelines:

Clarity of code is still important here -- and clear code is less likely to have bugs.

In particular, there should be very good and clear decisions in the code.

And there will be a penalty for usage of break or continue statements.

Planning out the design of the solution before diving into code will help!

The simplest solutions would use a list, but without any indexing on that list
(or use of range() to get those indexes).  Let Python help you fill and traverse the recipe.

Storing the entire recipe in a single list before splitting things up often produces much simpler programs than trying to store everything into multiple separate lists!

IMPORTANT NOTE: As above, the recipe is provided as input to the program -- it is not part of the program itself. The program may not assume it knows what the ingredients are, or how many there are, or which ingredients have fractions and which ones do not. It must work for any number of valid input lines.

TASKS:

Recipe Data Structure: Effectively uses list (either parallel lists or lists of structures)

Input Recipe: Clearly reads input until blank line encountered

Serving Inputs: Correctly inputs two values: how many recipe serves, and how many will be served

Computing the Scale: math.ciel; if/else to round up; or anything else equivalent

Parsing the ingredients: Correctly parses ingredients (using given 'tricks') May be done at any point in the program

Scaling the recipe: Multiplies whole numbers and numerators by chosen scaling factor

Output presentation: Uses string formatting to present output recipe

Compilation: Program runs fully without change (with valid inputs of 3+ words separated with single spaces)

Correctness: Program behaves as expected (accounting for known errors above)

Only Python 3.8 will be accepted.

8.30 LAB*: Program: Authoring assistant. PYTHON PLEASE!!

(1) Prompt the user to enter a string of their choosing. Store the text in a string. Output the string. (1 pt)

Ex:

Enter a sample text:
we'll continue our quest in space.  there will be more shuttle flights and more shuttle crews and,  yes;  more volunteers, more civilians,  more teachers in space.  nothing ends here;  our hopes and our journeys continue!

You entered: we'll continue our quest in space.  there will be more shuttle flights and more shuttle crews and,  yes;  more volunteers, more civilians,  more teachers in space.  nothing ends here;  our hopes and our journeys continue!

(2) Implement a print_menu() function, which has a string as a parameter, outputs a menu of user options for analyzing/editing the string, and returns the user's entered menu option and the sample text string (which can be edited inside the print_menu() function). Each option is represented by a single character.

If an invalid character is entered, continue to prompt for a valid choice. Hint: Implement the Quit menu option before implementing other options. Call print_menu() in the main section of your code. Continue to call print_menu() until the user enters q to Quit. (3 pts)

Ex:

MENU
c - Number of non-whitespace characters
w - Number of words
f - Fix capitalization
r - Replace punctuation
s - Shorten spaces
q - Quit

Choose an option:

(3) Implement the get_num_of_non_WS_characters() function. get_num_of_non_WS_characters() has a string parameter and returns the number of characters in the string, excluding all whitespace. Call get_num_of_non_WS_characters() in the print_menu() function. (4 pts)

Ex:

Number of non-whitespace characters: 181

(4) Implement the get_num_of_words() function. get_num_of_words() has a string parameter and returns the number of words in the string. Hint: Words end when a space is reached except for the last word in a sentence. Call get_num_of_words() in the print_menu() function. (3 pts)

Ex:

Number of words: 35

(5) Implement the fix_capitalization() function. fix_capitalization() has a string parameter and returns an updated string, where lowercase letters at the beginning of sentences are replaced with uppercase letters. fix_capitalization() also returns the number of letters that have been capitalized. Call fix_capitalization() in the print_menu() function, and then output the the edited string followed by the number of letters capitalized. Hint 1: Look up and use Python functions .islower() and .upper() to complete this task. Hint 2: Create an empty string and use string concatenation to make edits to the string. (3 pts)

Ex:

Number of letters capitalized: 3
Edited text: We'll continue our quest in space.  There will be more shuttle flights and more shuttle crews and,  yes;  more volunteers, more civilians,  more teachers in space.  Nothing ends here;  our hopes and our journeys continue!

(6) Implement the replace_punctuation() function. replace_punctuation() has a string parameter and two keyword argument parameters exclamation_count and semicolon_count. replace_punctuation() updates the string by replacing each exclamation point (!) character with a period (.) and each semicolon (;) character with a comma (,). replace_punctuation() also counts the number of times each character is replaced and outputs those counts. Lastly, replace_punctuation() returns the updated string. Call replace_punctuation() in the print_menu() function, and then output the edited string. (3 pts)

Ex:

Punctuation replaced
exclamation_count: 1
semicolon_count: 2
Edited text: we'll continue our quest in space.  there will be more shuttle flights and more shuttle crews and,  yes,  more volunteers, more civilians,  more teachers in space.  nothing ends here,  our hopes and our journeys continue.

(7) Implement the shorten_space() function. shorten_space() has a string parameter and updates the string by replacing all sequences of 2 or more spaces with a single space. shorten_space() returns the string. Call shorten_space() in the print_menu() function, and then output the edited string. Hint: Look up and use Python function .isspace(). (3 pt)

Ex:

Edited text: we'll continue our quest in space. there will be more shuttle flights and more shuttle crews and, yes, more volunteers, more civilians, more teachers in space. nothing ends here; our hopes and our journeys continue!

Assume that a three-year bridge construction project has just concluded resulting in a modern six-lane structure that spans a major river connecting two cities. Each of the two cities resides in a different state. The new bridge replaces a late-1940s steel structure two-lane bridge that was originally dedicated to World War II military veterans. The new bridge was constructed approximately 100 yards upstream from the bridge that it will be replacing. The old bridge is still standing and in operation, but destruction of the old bridge will begin approximately two weeks after the new bridge is dedicated and opened to traffic. The local Chambers of Commerce in each of the two cities connected by the bridge have been pushing for its replacement for the past 20 years. Various politicians at many state and local levels from each state have been actively involved (either in supporting or opposing the push to get the project funded, scheduled, and completed). At least two area historical groups have been vocal, especially in the past four years, about the old bridge's future. Representatives of smaller towns and cities along the major highways leading into the two cities that the new bridge connects have long supported the bridge renovation and have recently hailed it as a great boost to the region's economy. There are multiple newspapers in each of the two cities that the bridge connects, with one dominant newspaper that serves both markets. One of the cities connected by the bridge has four local television stations and the city in the other state has none. Workers from a general contractor and seventeen subcontractors have worked on the new bridge project, as well as employees of the primary Architectural firm and two consulting Architectural firms. Various state and federal government agencies have been directly or indirectly involved in the project as well. As the river spanned by the new bridge is a navigable river downstream from the bridge and also for a much shorter distance upstream from the bridge, the U.S. Army Corps of Engineers has also been actively involved. Various lobbying groups have supported or opposed the bridge project during its life and during the years leading up to the project getting started. These lobbyists have been the voice of many different types of groups that range across many interests from environmental groups to trucking industry groups as examples. As the new bridge has required that new highway approaches be constructed along each side of the river that it spans, various businesses and two very small residential neighborhoods have been impacted by the new bridge's approach roads. Several small businesses on either side of the river from the old bridge fear that life will change dramatically when the old bridge closes. The arts community in the region has successfully sought to provide input into the design of the new bridge and that bridge will feature special lighting to make it aesthetically appealing at night. The project manager for the new bridge and the key project team members have worked diligently for the entire duration of the project to bring the project to completion within one week of the scheduled completion date and slightly under budget. Inspection of the new bridge, to ensure that it meets specifications and is safe for the public, is currently underway and will be completed within the next month. The new bridge project has been completed with a combination of local, federal, and state (from each of the two states) funding. REQUIRED: Prepare a two-to-four page Microsoft Word format document (with one-inch margins all around in a 10 or 12-point Times New Roman or Arial font). Please place an appropriate assignment heading on the document containing the assignment number, the submitting student name, etc. in a format that is the same as students have been instructed to use in previous assignments in this course. In that document, please respond (in full sentences and appropriate paragraph structure) to the following two multi-part questions: 1. What should be done to ensure appropriate closure of this project and why? 2. Should this project have a project audit? Why or why not? If it should have a project audit, then how should that project audit be done and why? (Be sure to address the who, what, when, where, why, and how parts of this last subquestion as well as mentioning the general characteristics of a high-quality project audit effort, should you elect to state that a project audit should be done.)

Complete the following questions. In addition to answering the items below, you must submit an analysis of the assignment. Analyze the specific outcomes and write an analysis directed toward the management team at Smart Company describing what the numbers mean and how they relate to the business. Submit journal entries in an Excel file and written segments in an MS Word document. For written answers, please make sure your responses are well-written, formatted per CSU-Global Guide to Writing and APA and have proper citations, where applicable. Smart Company is preparing its financial statements for the year ended June 30, 2017. The financial statements are complete except for the statement of cash flows. You have been asked to prepare a statement of cash flows for the year ended June 30, 2017. Download the excel spreadsheet found in the link below. Required: Prepare a spreadsheet to support a statement of cash flows for the year ended June 30, 2017. In the tab named ‘Journal Entries’, show in journal entry form, the entries that would be made in preparation of the statement of cash flows. Prepare Smart Company’s statement of cash flows for the year ended June 30, 2017. Prepare the statement of cash flows using the indirect method. Note: For full credit, you must prepare the statement of cash flow in good form with all necessary disclosures, including disclosures about noncash financing and investing activities.

TWO MEANS – INDEPENDENT SAMPLES

Choose a variable from the advising.sav data set to compare group means. While the choice of which variable to test is up to you, you must remember that it must be a metric variable. The grouping variable, which is used to define the two groups to be compared, must be categorical.   You can look in the “Measure” column of the “Variable View” in the data file for help in determining which is which. The managerial question is whether or not there is a significant difference between the groups for the metric variable you have chosen.

Once you have the results, report your findings using the five step hypothesis testing procedure outlined in class. (See below.)   For Step 4, simply cut and paste the SPSS output into the report. This can be done by clicking on the desired portion of the output which will then be highlighted, and then right clicking on the highlighted portion and copying it to your flash drive. (Note that you may want to drop the results into a word document immediately since if you do not have SPSS on your personal laptop, you will not be able to open any SPSS output.) Then state the answer to the managerial question that was initially posed. For example, is there a significant difference between the two groups defined by the grouping variable (which you must identify in your report) for the metric variable tested? Also, interpret the confidence interval provided for the test. Does it indicate a significant difference or not?   

PAIRED SAMPLE T-TEST

Choose a pair of metric variables and run a paired sample t-test on the pair. Again, these must be metric variables. The managerial question will be “Is there a significant difference between the two variables?” for the pair. Report your findings using the same procedure described above, including an interpretation of the confidence interval.

REPORT(SAMPLE)

Your report will consist of two hypotheses tests, (one for the independent sample test and one for the paired sample test). It will look something like this (for the independent sample test):

1: H₀: μ₁= μ₂

H_a: μ₁ ≠ μ₂

2: Two group independent sample t-test (note that SPSS does everything as a t-test regardless of sample size).

3: α=.05 → t_crit = ±whatever the appropriate value is

4

5: Make a decision regarding the null hypothesis and interpret the confidence interval.

6: Answer the managerial question.

TWO RESULTS AFTER RUNNING

INDEPENDENT

PAIRED

PLEASE ANSWER TWO REPORTS INDEPENDENTLY ONE IS  INDEPENDENT AND THE OTHER IS PAIRED

AND PLEASE ANSWER AS SAMPLE REPORT STRUCTURE WITH 6 STEPS

Language: C++

I am starting to make a Bigint ADT and i have the hpp file finished now i need to make the methods for the functions.

Problem:
The data type int in C++ is limited to the word size of the CPU architecture (e.g., 32 or 64 bit). Therefore you can only work with signed integers up to 2,147,483,647 (in the case of signed 32 bit). Unsigned 32 bit is still only 10 digits. Maxint for 64 is somewhat larger at 9,223,372,036,854,775,807 but still only 19 digits. Clearly, this causes difficulties for working with very large integer values (say 100 digits). Your job is to develop an ADT (called bigint) that can take any size postive integer. It will work for 100, 200, 500, etc. digit integers.

Representation is a key issue for this assignment. We recommend an array of integers, with each element representing one single digit (0 to 9) of the big number. One could use an array of char, but the memory savings is pretty minimal. Placing the values in the array is the interesting part. The naïve representation makes storing the bigint easy but makes the operations (add and multiply) very difficult to implement. A slightly more clever representation makes storing the big number a little bit harder but makes implementing the operations way easier.

Arrays are typically drawn to be read left to right with the 0 element on the left and the largest on the right. However, arrays are a completely made up concept and are not physical in nature. So you can draw them and think about them anyway you want. For this problem having the right side as the 0 element and the left side as the largest makes much more sense.

Take the example of the number 299,793. We show how it is stored in the array below. The 3 is in the one's position, the 9 in the 10's position and so on. This neatly corresponds to the index of the array. The addition and multiple algorithms given below use this representation.

bigint

Directions:

• The capacity of the bigint must be specified by a global constant CAPACITY, use: const int CAPACITY = 400;
• A default constructor to initialize a bigint to zero.
• A constructor to initialize a bigint to an int value you provide [0, maxint]. Example: bigint(128).
• A constructor to initialize a bigint to a const char[] you provide. You can assume what is provided is a valid bigint. Example: bigint("299793").
• Develop a method called debugPrint that will be helpful for debugging your bigint. Use a method defintition of void debugPrint(std::ostream&) const; It simply prints out every element of your bigint array starting from the highend (e.g., capacity-1) of the bigint to zero. Printing a "|" between each value will also be pretting helpful to help with debugging.
• Overload output operator<< as a friend or free function, so that takes a stream and bigint as input and writes the bigint to the stream. It will print at most 80 digits per line. No leading zeros are to be printed.
• Overload operator== to compare if two bigints are equal. It returns a bool - true if equal and false otherwise.

• using namespace std; is stricly forbiden. As are any global using statements.
• You can NOT use a pre-defined library or built in class (such as std::vector or std::string) to solve this problem. Use a standard array to solve the problem. You also do not need to solve any part of this problem.

bigint.hpp:

#ifndef BIGINT_HPP
#define BIGINT_HPP

const int CAPACITY = 400;

class bigint {
public:
bigint(); //default constructor
bigint(int);
bigint(const char[]);
void debugPrint(std::ostream&) const;
bool operator<< (const bigint&) const;
bool operator== (const bigint&) const;
private:
int j_[CAPACITY];
int num;
};

bigint.cpp: // start of method file

#include
#include "bigint.hpp"

bigint::bigint(){
for(int i=0;i j_[i]=0;
}
}

bigint::bigint(int){

}

bigint::bigint(const char[]){
}

On October 1, 2016, Adria Lopez launched a computer services company called Success Systems, which provides consulting services, computer system installations, and custom program development. Adria adopts the calendar year for reporting purposes and expects to prepare the company's first set of financial statements on December 31, 2016. The company's initial chart of accounts and transactions follows. Account No. Account No. Cash 101 Common Stock 307 Accounts Receivable 106 Dividends 319 Computer Supplies 126 Computer Services Revenue 403 Prepaid Insurance 128 Wages Expense 623 Prepaid Rent 131 Advertising Expense 655 Office Equipment 163 Mileage Expense 676 Computer Equipment 167 Miscellaneous Expenses 677 Accounts Payable 201 Repairs Expense - Computer 684 Oct. 1 Adria Lopez invested $55,000 cash, a $20,000 computer system, and $8,000 of office equipment in the company in exchange for its common stock. The company paid $3,300 cash for four months' rent. (Hint: Debit Prepaid Rent for $3,300.) The company purchased $1,420 of computer supplies on credit from Harris Office Products. The company paid $2,220 cash for one year's premium on a property and liability insurance policy. (Hint Debit Prepaid Insurance for $2,220.) The company billed Easy leasing $4,800 for services performed in installing a new Web server. 8 The company paid $1,420 cash for the computer supplies purchased from Harris Office Products on October 3. 10 The company hired Lyn Addie as a part-time assistant for $125 per day, as needed. 12 The company billed Easy leasing another $1,400 for services performed. 15 The company received $4,800 cash from Easy Leasing as partial payment on its account. 17 The company paid $805 cash to repair computer equipment that was damaged when moving it. 20 The company paid $1,940 cash for advertisements published in the local newspaper. 22 The company received $1,400 cash from Easy Leasing on its account. 28 The company billed IFM Company $5,208 for services performed. 31a The Company paid $875 cash for Lyn Addie's wages for seven days' work. 31b The Company paid $3,600 cash in dividends. Nov. 1 The Company reimbursed Adria Lopez in cash for business automobile mileage allowance (Lopez logged 1,000 miles at $0.32 per mile). 2 The company received $4,633 cash from Liu Corporation for computer services performed. 5 The company purchased computer supplies for $1,125 cash from Harris Office Products. 8 The company billed Gomez Co. $5,668 for services performed. 13 The company received notification from Alex's Engineering Co. that Success Systems' bid of $3,950 for an upcoming project is accepted. 18 The company received $2,208 cash from IFM Company as partial payment of the October 28 bill. 22 The company donated $250 cash to the United Way in the company's name. The company completed work for Alex's Engineering Co. and sent it a bill for $3,950. The company sent another bill to IFM Company for the past-due amount of $3,000. 28 The company reimbursed Adria Lopez in cash for business automobile mileage (1,200 miles at $0.32 per mile). 30a The Company paid $1,750 cash for Lyn Addie's wages for 14 days' work. 30b The Company paid $2,000 cash in dividends. Required: Using Micro Soft Excel and Word: Prepare journal entries to record each of the above transactions for Success Systems. (If no entry is required for a particular transaction, select "No journal entry required” in the first account field.) Post the journal entries to ledger accounts. (Add additional ledger accounts when necessary.) Prepare a trial balance as of the end of November. (Trial Balance total $ 108,659) (Be sure to show formulas in your worksheets.) This question has been posted but the answer is wrong please review and help thanks I found the mistake in the answer the 11/2 transaction shoud be cash debit revenue credit your welcome!

1.             Develop a simple linear regression model to predict the price of a house based upon the living area (square feet) using a 95% level of confidence.

1.             Write the reqression equation
2.             Discuss the statistical significance of the model as a whole using the appropriate regression statistic at a 95% level of confidence.
3.              Discuss the statistical significance of the coefficient for the independent variable using the appropriate regression statistic at a 95% level of confidence.
4.             Interpret the coefficient for the independent variable.
5.             What percentage of the observed variation in housing prices is explained by the model?
6.              Predict the value of a house with 3,000 square feet of living area.

2.             Develop a simple linear regression model to predict the price of a house based upon the number of bedrooms using a 95% level of confidence.

1.             Write the reqression equation
2.             Discuss the statistical significance of the model as a whole using the appropriate regression statistic at a 95% level of confidence.
3.              Discuss the statistical significance of the coefficient for the independent variable using the appropriate regression statistic at a 95% level of confidence.
4.             Interpret the coefficient for the independent variable.
5.             What percentage of the observed variation in housing prices is explained by the model?
6.              Predict the value of a house with 3 bedrooms.

3.             Develop a simple linear regression model to predict the price of a house based upon the number of bathrooms using a 95% level of confidence.

1.             Write the reqression equation
2.             Discuss the statistical significance of the model as a whole using the appropriate regression statistic at a 95% level of confidence.
3.              Discuss the statistical significance of the coefficient for the independent variable using the appropriate regression statistic at a 95% level of confidence.
4.             Interpret the coefficient for the independent variable.
5.             What percentage of the observed variation in housing prices is explained by the model?
6.              Predict the value of a house with 2.5 bathrooms.

4.             Develop a simple linear regression model to predict the price of a house based upon its age using a 95% level of confidence.

1.             Write the reqression equation
2.             Discuss the statistical significance of the model as a whole using the appropriate regression statistic at a 95% level of confidence.
3.              Discuss the statistical significance of the coefficient for the independent variable using the appropriate regression statistic at a 95% level of confidence.
4.             Interpret the coefficient for the independent variable.
5.             What percentage of the observed variation in housing prices is explained by the model?
6.              Predict the value of a house that is 50 years old.

5.             Compare the preceding four simple linear regression models to determine which model is the preferred model. Use the Significance F values, p-values for independent variable coefficients, R-squared or Adjusted R-squared values (as appropriate), and standard errors to explain your selection.
6.             Calculate the predicted sale price of a 50 year old house with 3,000 square feet of living area, 3 bedrooms, and 2.5 bathrooms using your preferred regression model from part 5.

Prepare a single Microsoft Excel file, using a separate worksheet for each regression model, to document your regression analyses. Prepare a single Microsoft Word document that outlines your responses for each portions of the case study.

Selling Price        Age (Years)         Living Area (Sq Feet)       No. Bathrooms No Bedrooms

$92,000                 18           1,527     2              4

$211,002              0              2,195     2.5          4

$115,000              14           1,480     1.5          3

$113,000              53           1,452     2              3

$216,300              0              2,360     2.5          4

$145,000              32           1,440     1              3

$114,000              14           1,480     2.5          2

$139,050              125         1,879     2.5          3

$104,000              14           1,480     1.5          3

$169,900              11           1,792     2.5          3

$177,900              2              1,386     2.5          3

$133,000              14           1,676     2              2

$185,000              0              768         2              4

$115,000              16           1,560     1.5          3

$100,000              91           1,000     1              3

$117,000              15           1,676     1.5          4

$150,000              11           1,656     1.5          3

$187,500              11           2,300     1.5          3

$107,000              25           1,712     1              3

$126,900              26           1,350     1.5          3

$147,000              15           1,676     2.5          3

$62,000                 103         1,317     1.5          3

$101,000              30           1,056     2              3

$143,500              13           912         1              3

$113,400              18           1,232     2              2

$112,000              36           1,280     1              3

$112,500              43           1,232     1              3

$97,000                 45           1,406     1.5          3

$121,000              6              1,164     2              3

$65,720                 123         1,198     1              3

$225,000              10           2,206     2.5          4

Question

Objective:

The objective of this lab exercise is to give you practice in programming with one of Python’s most widely used “container” data types -- the List (commonly called an “Array” in most other programming languages). More specifically you will demonstrate how to:

1. Declare list objects
2. Access a list for storing (i.e., writing) into a cell (a.k.a., element or component) and retrieving (i.e., reading) a value from a list cell/element/component
3. Iterate through a list looking for specific values using a for…in loop repetition construct
4. Pass an entire list argument to a function
5. Process a list parameter received by a function

Discussion:     

For this exercise you will be simulating a Weather Station responsible for recording hourly temperatures and reporting on certain characteristics (e.g., average temperature) from your recordings. You will also be expanding on your experience in creating functions and passing them more complex parameters (i.e., complete list arguments – sometimes empty and sometimes full).

Specifications:

DDI&T a Python program to input, store, and process hourly temperatures for each hour of the day (i.e., 24 temperatures). Your program should be divided logically into the following parts:

1. In function main() declare an empty List container:

         HourlyTemperatures = []    

2. Pass the empty HourlyTemperatures list to a function,

GetTemperatures(HourlyTemperatures)

         This function must interactively prompt for and input temperatures for each of the 24 hours in a day (0 through 23). For each temperature that is input, verify that its value lies in the range of minus 50 degrees and plus 130 degrees (i.e., validate your input values). If any value is outside the acceptable range, ask the user to re-enter the value until it is within this range before going on to the next temperature (HINT: use a nested loop (e.g., Python’s equivalent to a do-while loop) that exits only when a value in the specified range has been entered). Store each validated temperature in its corresponding element of the list container passed as a parameter to the function (Hint: Look at the ‘append(…)’ function that can be called on a list container).

3. Next pass the filled list container to a function,

ComputeAverageTemp(HourlyTemperatures)

         This function computes the average temperature of all the temperatures in the list and returns this average to the calling function.

4. Finally, pass the filled list container and the computed average temperature to another function,

                  DisplayTemperatures(HourlyTemperatures, AverageTemp)

         which displays the values of your temperature list in a columnar format followed by the values for the high temperature, low temperature, and average temperature for the day.  NOTE: If you want to create separate function(s) to find and return the high and low temperature values, then feel free to do so!

The resulting output should look something like this:

Hour                          Temperature

00:00                                42

01:00                                42

. . . . .                                . . . // Your program output must include all of these too!

22:00                                46

23:00                                48

High Temperature:          68

Low Temperature:           42

Average Temperature:    57.4

5.      Since you have several created functions to perform each of the major steps of your solution, your main(): function should be quite simple. The pseudo code for main() might look something like this:

                  main()

                       #declare any necessary variable(s) and HourlyTemperatures list

                       while user-wants-to-process-another-days’-worth-of-temperatures

                           call GetTemperatures(HourlyTemperatures)

                                 call ComputeAverageTemp(HourlyTemperatures)

                                 call DisplayTemperatures(HourlyTemperatures, AverageTemperature)

                                 ask if user want to process another days’ worth of temperatures

6.      Test your program with at least two (2) different sets of temperatures. Make sure you enter values to adequately test your temperature-validation code (e.g., temperatures below –50 and above +130 degrees).

Deliverable(s):

Your deliverable should be a Word document with screenshots showing the sample code you have created, and discuss the issues that you had for this project related to AWS and/or Python IDE and how you solved them.

Turn in the properly documented source listing of your program and complete outputs from at least TWO (2) test “runs”. Additionally, turn in screen captures of some of your interactive inputs demonstrating that your program properly detects invalid inputs and prompts the user to re-enter the temperature(s).