Posts in category: Uncategorized

Project Description:

You are the office manager for a real estate company in northern Utah County. You tracked real estate listings, including city, agent, listing price, sold price, etc. Agents can represent a seller, a buyer, or both (known as dual agents). Your assistant prepared the spreadsheet structure with agent names, agent types, the listing and sold prices, and the listing and sold dates. You want to complete the spreadsheet by calculating the number of days each house was on the market before being sold, agent commissions, and bonuses. In addition, you will use conditional functions to calculate summary statistics. For further analysis, you will insert a map chart to indicate the average house selling price by city. Finally, you will create a partial loan amortization table and calculate cumulative interest and principal to show a potential buyer to help the buyer make decisions.

The   spreadsheet contains codes (BA, DA, SA) to represent agent roles (Buyer’s   Agent, Dual Agent,   Seller’s Agent). You want to switch the codes for the actual descriptions.
  In cell E12 of the Details sheet, insert the SWITCH function to evaluate the   agent code in cell D12. Include mixed cell references to the codes and roles   in the range J2:K4 for the values
  and results arguments. use all cell references in the function. Copy the   function to the range E13:E39.

Now you want to calculate the   number of days between the list date and sale date.
 

  In cell J12, insert the DAYS function to calculate the number of days between   the Listing Date and the Sale Date. Copy the function to the range J13:J39.

You want to calculate agent   commissions based on their role.
 

  In cell K12, insert the IFS function to calculate the agent’s commission   based on the agent code and the applicable rates in the range L2:L4. Use   relative and mixed references correctly. Copy the function to the range   K13:K39.

You want to calculate a bonus if   the sold price was at least equal to the listing price, and if the house sold   within 30 days after being listed.
 

  In cell L12, insert an IF function with a nested AND function to calculate a   bonus. The AND function should ensure both conditions are met: Sold Price   divided by the Listing Price is greater than or equal to 100% (cell L7) and   the Days on Market are less than or equal to 30 (cell L8). If both conditions   are met, the bonus is $1,000 (cell L9). Otherwise, the bonus is $0. Use mixed   cell references to the input values in the range L7:L9. Copy the function to   the range L12:L39.

The top-left section of the   spreadsheet is designed for summary statistics for one condition. You will   calculate average selling prices and the number of houses sold in each city   (the condition).
 

  In cell B2, insert the AVERAGEIF function to calculate the average Sold Price   for houses in the city of Alpine. Use mixed references for the range; use a   relative reference to cell A2. Copy the function and use the Paste Formulas   option to paste the function in the range B3:B5 so that the bottom border in   cell B5 is preserved.

You want to count the number of   houses in one city.
 

  In cell C2, insert the COUNTIF function to count the number of houses in the   city of Alpine. Use mixed references for the range; and use a relative   reference to cell A2. Copy the function and use the Paste Formulas option to   paste the function in the range C3:C5 so that the border in cell C5 is   preserved.

You want to calculate the total commissions   for each agent (the condition).
 

  In cell B7, insert the SUMIF function to total the commissions by agent. Use   mixed references for the ranges; and use a relative reference to cell A7.   Copy the function and use the Paste Formulas option to paste the function in   the range B8:B9 so that the borders are preserved.

The top-middle section of the   spreadsheet is designed for summary statistics for multiple conditions. You   will calculate the number of houses sold for each agent when he or she served   as a Dual Agent (DA). Use mixed references for ranges and the agent code   condition in cell J3. Use relative cell references to the agent condition in   cell E2. When you copy the formulas, use the paste Formulas options to   preserve border formatting.
 

  In cell F2, insert the COUNTIFS function in cell F2 to count the number of   houses sold by the first agent (cell E2) who was a Dual Agent (DA) (J3) for   that house. Use all cell references in the function. Copy the function to the   range F3:F4 and preserve the bottom border for cell F4.

You are ready to calculate the   total value of those houses for each agent when he or she served as a Dual   Agent (DA). Use mixed references for ranges and the agent code condition in   cell J3. Use relative cell references to the agent condition in cell E2. When   you copy the formulas, use the paste Formulas options to preserve border   formatting.
 

  In cell G2, insert the SUMIFS function to sum the selling prices of the   houses sold by the first agent (cell E2) who was a Dual Agent (DA) (J3) for   that house. Copy the function to the range G3:G4 and preserve the bottom   border for cell G4.

Now, you will calculate the   highest-price house highest-price house sold for each agent when he or she   served as a Dual Agent (DA). Use mixed references for ranges and the agent   code condition in cell J3. Use relative cell references to the agent   condition in cell E2. When you copy the formulas, use the paste Formulas   options to preserve border formatting.
 

  In cell H2, insert the MAXIFS function in cell H2 to display the highest-price   house sold by the first agent (cell E2) who was a Dual Agent (DA) (J3) for   that house. Copy the function to the range H3:H4 and preserve the borders in   the range H3:H4.

The Map worksheet contains a   list of cities, postal codes, and average house sales. You will insert a map   chart to depict the averages visually using the default gradient fill colors.
 

  Display the Map worksheet, select the range B1:C5 and insert a map chart.

Cut the map chart and paste it   in cell A7. Set a 2.31″ height and 3.62″ width.

You want to enter a meaningful   title for the map.
 

  Change the map title to Average Selling Price by Zip Code.

Display the Format Data Series   task pane, select the option to display only regions with data, and show all   labels. Close the task pane.

You are ready to start   completing the loan amortization table.
 

  Display the Loan worksheet. In cell B8, type a reference formula to cell B1.   The balance before the first payment is identical to the loan amount. Do not   type the value; use the cell reference instead. In cell B9, subtract the   principal from the beginning balance on the previous row. Copy the formula to   the range B10:B19.

Now, you will calculate the   interest for the first payment.
 

  In cell C8, calculate the interest for the first payment using the IPMT   function. Copy the function to the range C9:C19.

Next, you will calculate the   principal paid.
 

  In cell D8, calculate the principal paid for the first payment using the PPMT   function. Copy the
  function to the range D9:D19.

Rows 21-23 contain a summary   section for cumulative totals after the first year.
 

  In cell B22, insert the CUMIPMT function that calculates the cumulative   interest after the first year. Use references to cells A8 and A19 for the   period arguments.

The next summary statistic will   calculate the principal paid after the first year.
 

  In cell B23, insert the CUMPRINC function that calculates the cumulative   principal paid after the first year. Use references to cells A8 and A19 for   the period arguments.

Rows 25-28 contain a section for   what-if analysis.
 

  In cell B27, use the RATE financial function to calculate the periodic rate   using $1,400 as the
  monthly payment (cell B26), the NPER, and loan amount in the original input   section.

In cell B28, calculate the APR   by multiplying the monthly rate (cell B27) by 12.

Create a footer with your name   on the left side, the sheet name code in the center, and the file name code   on the right side of each worksheet.

What are the different ideas to improve and to make better projects in android?

Question Comparing between your Current Operating system and Linux
 

Your assignment is to install a version of Linux on your computer. If you have Windows already installed, you may be also able to install Linux in a dual-boot mode. Read the documentation before doing so.
 

You will need to go to the link below to download Fedora Linux and use either ftp or http to download the ISO disks. You may also download a DVD disk ISO image, if desired. Follow the directions at this link. If you already have Linux installed, then see alternate requirements below. (You may use other versions of Linux — only links are provided here for Fedora). Note the latest versions of Fedora have a live DVD which means you can run the operating system from the DVD player. Also other versions of Linux will be fine to download like
 

Ubuntu (http://www.ubuntu.com/).
 

Fedora (sponsored by Redhat) (http://fedora.redhat.com/download/)
 

Getting started with Ubuntu 12.10 from:
 

http://files.ubuntu-manual.org/manuals/getting-started-with-ubuntu/12.10/en_US/screen/Getting%20Started%20with%20Ubuntu%2012.10.pdf
 

Read the manual included at the end of the background information for this module. The following materials may be helpful in setting up your Linux Operating System (note, these are for the version of Linux prior to Fedora but should work in most cases — see the release notes for more up-to-date information).
 

Getting started with Ubuntu 12.10
 

Red Hat Linux x86 Installation Guide
 

Red Hat Linux Getting Started Guide
 

Red Hat Linux Customization Guide
 

Red Hat Linux Reference Guide
 

Red Hat Linux System Administration Primer
 

Red Hat Linux Security Guide
 

Required:
 

Describe your experience and comment on the relative comparisons you see between Windows (or your current operating system) and Linux in a 1- to 2-page paper. If you already are a Linux user, write a 1- to 2-page paper on the hidden cost of Linux and how you believe Linux will evolve in the next year as operating systems. Submit evidence which demonstrates that you have installed Linux on your computer as per the above.
 

SLP Assignment Expectations
Use information from the modular background readings as well as the given resources. Also, you could use any good quality resource you can find. Please cite all sources and provide a reference list at the end of your paper.
 

PAPER LENGTH: 1-2 pages and double-spaced.
 

The following items will be assessed in particular:
 

Your ability to consolidate ideas from reading materials and your understanding of the materials.
A well written report with strong arguments.
Evidence which demonstrates that you have installed Linux on your computer.

 You will review qualitative research.  The topic is up to you as long as you choose a peer-reviewed, academic research piece.  I suggest choosing a topic that is at least in the same family as your expected dissertation topic (cybersecurity) so that you can start viewing what is out there.

 Please use APA formatting and include the following information:

• Introduction/Background:  Provide context for the research article.  What led the author(s) to write the piece? What key concepts were explored? Were there weaknesses in prior research that led the author to the current hypothesis or research question?
• Methodology:  Describe how the data was gathered and analyzed.  What research questions or hypotheses were the researcher trying to explore? What statistical analysis was used?
• Study Findings and Results:  What were the major findings from the study? Were there any limitations?
• Conclusions:  Evaluate the article in terms of significance, research methods, readability and the implications of the results.  Does the piece lead into further study? Are there different methods you would have chosen based on what you read? What are the strengths and weaknesses of the article in terms of statistical analysis and application? (This is where a large part of the rubric is covered.) 

500 words with references needed.

The benefits of the Mobile applications in the business Process

This should follow the format below

a.) Introductory Paragraph

b.) Body Paragraph

c.) Concluding Paragraph

d.) References

REMEMBER: The purpose of this assignment is NOT to copy and paste information from the text (this is plagiarism), but rather to clearly convey subject knowledge and use critical thinking in formulating your response. Always use your own words.

MUST BE MORE THAN One-sentence responses.

PROVIDE APA Reference 

ACCESS THE BOOK HERE FOR CHAPTERS 3-4: https://learning-oreilly-com.ezproxy1.apus.edu/library/view/managing-risk-in/9781284055955/11_ch3.xhtmlBe sure to address each question individually and number your response.

Chapter 3-4 Questions.

Each Question is worth 20 points each

Chapter 3

1. Name and Describe two (2) U.S. based compliance laws that exist.

2. Discuss the levels of the CMMI process improvement approach.

Chapter 4

1. What is Scope and why is it important to a Risk Management Project?

2. What is a Cost Benefit Analysis and Why is it important?

3. Name and Describe the three (3) types of project management charts.

Securing IoT Devices: What are the Challenges?

Security practitioners suggest that key IoT security steps include:

1) Make people aware that there is a threat to security;

2) Design a technical solution to reduce security vulnerabilities;

3) Align the legal and regulatory frameworks; and

4) Develop a workforce with the skills to handle IoT security.

Final Assignment – Project Plan (Deliverables):

Address each of the FOUR IoT security steps listed above in terms of IoT devices.

Explain in detail, in a step-by-step guide, how to make people more aware of the problems associated with the use of IoT devices.

please refer to the following link for more info

https://rpubs.com/putriangelinaw/econometrics10

Use the following help function to pull the data on r

??gafa_stock
??PBS
??vic_elec
??pelt

I just need the code to run it.

8. Tsibble and mutate practice: Import a year of stock (of your choosing) closing price data (feel free to use gafa_stock within FPP3 or quantmod package. Convert this data to a tsibble. Plot differences and correlogram of the differences and comment on whether the differences resemble white noise (reference FPP3 2.10, #12 for code help dFB <- gafa_stock %>%
filter(Symbol == “FB”, year(Date) >= 2018) %>%
mutate(trading_day = row_number()) %>%
update_tsibble(index = trading_day, regular = TRUE) %>%
mutate(diff = difference(Close))
view(dFB)).

9. Reindexing and plotting practice: Vic_elec dataset

a. Plot daily demand year over year for vic_elec dataset (within FPP3)

b. Is temperature correlated to demand?

c. Is previous day demand correlated with current demand?

For below problems please reference https://r4ds.had.co.nz/dates-and-times.html

10. Datetime components: nycflights13 (

library(nycflights13)

#ensure you have the tables loaded and preview
flights
weather

#check what tables are in the ‘nycflights13’ package
data(package=’nycflights13′))

a. Load the flights table from the nycflights13 package

b. What day of the week has the highest average delay?

11. Time zones: Reindex vic_elec to the US Eastern timezone using the with_tz function

12. Durations and periods

a. Create a duration for your age at the start of our first lecture and print this duration.

b. Calculate your age at the end of the semester (4/27/22 8:50p) using periods

 Exam 1 Su 22b

Project Description:

Apply all of the skills that you have learned in CS 235 so far by Communicating Information and Converting Data into Information using the data from Happy Place Incorporated and Excel.

Start Excel. Download and open   the file named Exam1.xlsx. Remember to SAVE   OFTEN (after every step is suggested). Save where you can find it (DO NOT   SAVE in DOWNLOADS). Goodluck!

On the New Location worksheet, merge and center the   Loan Information Sheet title in A1 through the range A1:G1. Next, merge and center   the date in A2 through the range A2:G2.
  To the title in A1, apply Light Orange, 60% – Accent2 cell style, apply bold,   and change the font size to 22 (in that order).
  Apply Note cell style to the date in A2.

On the New Location worksheet, in the range A4:A6,   wrap the text, apply Right alignment, apply Orange, Accent 2, Darker 25% fill   color, and apply White, Background 1 font color.
  Change the column width of A to 15.
  Center align the Potential Monthly Payments (Q1-Q2) subtitle in cell B16 and apply   Heading 4 cell style.

On the New Location worksheet, apply the Accounting   format with two decimal places to the range C18:H25.
  Create a conditional formatting rule that will display cells in the range   C18:H25 in the Green – Yellow – Red Color Scale.
  Create a conditional formatting rule that will apply Red text to the top 3   values in the range C18:H25.

On the New Location worksheet, in cell F7, enter a   payment function that calculates the monthly payment of the new location   using the information provided in B4:B6, E7:E9, F6:H6 and appropriate cell   referencing. Be sure that the monthly payment is a positive value.
  Copy the function through F7:H9.

On the Quarterly   Location Overhead worksheet,   apply the Number format with a comma and 0 decimal places to the range   C5:F11.
  In the range C15:C18, enter functions that will appropriately calculate the   Total, Maximum, Minimum, and Average for the 1st Qtr.
  Copy the functions to D15:F18 to calculate all values for the remaining   quarters. 

On the Quarterly   Location Overhead worksheet,   apply a bottom border to C11:F11.
  Apply Currency Format with zero decimal places to the range C15:F18.
  In cell B21, use a function to count the number of stores in column B   beginning in row 5 and ending in row 11.

On the Product Info worksheet, select cell F4. Insert an if function to see if there will   be a tax on the swim apparel based on the unit price. If the unit price is greater than or equal   to $25, then display the dollar amount of the tax (.065 times the Unit   Price). If the unit price is less than   $25, then there will not be any tax, display a 0. Use cell reference G2   within your function. Use appropriate   cell referencing and copy the function to
  F4:F8.

On the Product Info worksheet, in cell C15, enter a   date function that returns today’s date. Format C15 to Long Date.
  In, cell F18, insert a lookup function that looks up the Item Code, compares   it to the Product List range in column C, D, and E; and returns the Unit   Price using appropriate cell referencing. Copy the function down through the range F19:F22.

On the Product Info worksheet, select G18 and enter   a formula that will multiply the quantity (D18) and the Unit Price (F18).   Copy that formula down through the range (G19:G22). 

On the Product Info worksheet, select Landscape   orientation, set a 1.1-inch bottom margin, and center the worksheet data   horizontally and vertically on the page.

On the Product Info worksheet, in the range G29:G35,   insert Line Sparklines to show the customer trends for each location over the   five-year period. Apply Dark Green, Sparkline Style Colorful #4.
  Show the High Point and Low Point.
  Change the color of the High Point marker to Blue.

On the Product Info worksheet, select the range   G29:G35, apply Same for All Sparklines for the vertical axis maximum.

On the Product Info worksheet, insert a 2-D Pie   Chart using the ranges A28:F28 and A29:F29. Edit the Chart Title to Customers by   Location.
  Cut and paste the chart to A39.
  Apply Style 5 chart style to the pie chart.
  Explode the 2017 data point by 15%.
  Change the chart height to 4.5 inches and the chart width to 4.5 inches.
  Add Alt Text College Cafe first quarter customer attendance by   location (2017-2021). (include   period)

On the Product Info worksheet, select the ranges   A28:F29 and A33:F33 and create a stacked column chart.
  Move chart to a new sheet named Column Chart.
  Do not show the Chart Title.
  Apply Style5 chart style to the column chart.
  Apply the Light Gradient – Accent 3 Fill to the plot area.
  Change the Legend font size to 10.

On the Column Chart worksheet, add a Value Vertical   Axis Title Customers, then set the Maximum bound to 20000, and the   Minimum bound to 0.
  Change the value axis display units to Thousands.
  Add Data Labels to the Center and show ONLY the Value and Show Leader Lines.
  For the West Lafayette Data Series Data Labels, format to Number format with   1 decimal place.

Click the College Cafe   Revenue tab,   convert the data to a table named Revenue.
  Apply Green, Table Style Medium 7.
  Change the row 1 height to 18.
  Create a custom sort so that the table is sorted by Month: January, February,   March.
  Add another Sort level to sort the data by Location in alphabetical order and   then by Category in alphabetical order, then by Amount in descending order   (largest to smallest). 

On the College Cafe   Revenue   worksheet, add a total row to display the average of the Amount column. Apply a filter to display only Amounts that   are greater than 2000.
  Freeze the first row of the Revenue table.
  Set the range A1:E142 (Revenue table) as a print area.
  Set row 1 to repeat when printed.

In the College Cafe   Revenue sheet,   create a PivotTable named Revenue using the data range A1:E142, and place it on the same   worksheet, in cell G31.
  Add Amount to the Values and Product to the Rows.
  Change the Pivot Table style to Dark Grey Pivot Style Dark 4.
  Type Product in cell G31.

In the College Cafe   Revenue sheet   in the Revenue PivotTable, modify the Sum of Amount Field to summarize value   by Average instead of Sum. Next change the custom name to Amounts. Change the number format to   Accounting with 0 decimal places.

In the College Cafe   Revenue sheet,   create a calculated field (using the default name) that multiples Amount by   0.57 to find estimated cost.
  After the field is created, change its custom name to Estimated   Cost.
  Change the number format to Currency with two decimal places.

In the College Cafe   Revenue sheet,   on the PivotTable, Insert a Slicer for Location field.
  Change style to Light Orange, Slicer Style Light 2.
  Set Slicer height to 3. Set Button width to 1.8.
  Cut and paste to J32.
  Use the slicer to include only West Lafayette and Bloomington to be included   in the PivotTable. 

In the College Cafe   Revenue sheet,   create a clustered column PivotChart named Products from the Revenue   PivotTable.
  Cut and paste the PivotChart to G43.
  Hide all field buttons in the PivotChart.

In the College Cafe   Revenue sheet,   on Products PivotChart, add a chart title above the chart and type Estimated   Margin.
  Change the fill color for Estimated Cost data series only to Green, Accent 6.   
  Move legend to bottom of chart.
  Add a Linear Trendline to Estimated Cost.

In the Subtotals worksheet, sort the data by   Product in alphabetical order. Use the   Subtotal feature to calculate the average Amount, by Product.
  Display only the averages and grand average.
  Expand the details for Plain Bagel Average.

Switch to the Gala Catering sheet, load the Solver add-in   if it is not already loaded. Set the objective cell to calculate the Balance   of $11,000 for Fundraiser catering.Use Tickets Sold and Price of Ticket as   changing variable cells.
 

  Use the Constraint section A10:B13 to set constraints for minimum ticket   price, maximum ticket price, and ticket sales.
  Number of tickets sold must be an integer.
  Total tickets sold must not be greater than the Venue capacity.
  Price of Ticket must not be greater than the Maximum Ticket Price and must   not be less than the Minimum Ticket Price.
 

  Solve the problem. Generate the Answer Report and Keep Solver Solution.
 

On the Gala Catering sheet, create an appropriate   range name for Meal (cell B7).
  Edit the existing name range Meal to Meal_Cost.
  Use the newly created range name to create a formula to calculate Total Meal   Cost (cell B8) by multiplying sold tickets and Meal_Cost.

Switch to the Payment worksheet, beginning in cell   E3, complete the series of loan amount values in column E ranging from   $40,000 to $80,000 in $5000 increments.
  Beginning in cell F2, complete the series from 2.5% to 5.5% in .50%   increments for row 2.
  In cell E2, reference the cell that contains the Monthly Payment.
  Apply a custom number format to display Monthly Payment.
  Complete the two-variable data table using the Interest Rate and Amount of   Loan as the input cells.

On the Payment worksheet using the data in   A15:B40, create a scenario named Best Case, using Tickets Sold and Price of   Ticket. Enter these values for the scenario: 445 and 195.
 

  Create a second scenario named Worst Case, using the same changing cells.   Enter these values for the scenario: 100 and 80.
 

  Generate a scenario summary report using Total Income and Balance.

Save your file as Exam 1   Complete_Your Name and close the Excel file. Upload your completed Exam 1   Complete_Your Name file to MyITLab.
Please   be sure that you are uploading the CORRECT completed exam file.  You only have 1 submission. If you submit   the starting file by accident, you will not receive any points for exam 1 (no   exceptions). This is why we had you change the name of   your completed file at the end, so this won’t happen. Again, please please make sure to upload   Exam 1 Complete_Your Name.xlsx (your completed exam) for grading. Check your   submission to make sure it has been submitted.
  If anything goes wrong, notify the course staff ASAP. Once any time has   passed, the file that you submit is final and there is nothing we can do.   PLEASE DOUBLE CHECK !! 

As a business analyst in the Chief Information Officer’s (CIO’s) department of Maryland Technology Consulting (MTC), you have been assigned to conduct an analysis, develop a set of system requirements, evaluate a proposed solution, and develop an implementation plan for an IT solution (applicant tracking or hiring system) to improve the hiring process for MTC. This work will be completed in four stages, and each of these four stages will focus on one section of an overall Business Analysis and System Recommendation (BA&SR) report to be delivered to the CIO.