All posts by : chebby

Write a research paper discussing the concept of risk modeling. Please also evaluate the importance of risk models. Lastly, construct an approach to modeling various risks and evaluate how an organization may make decisions about techniques to model, measure, and aggregate risks. 

Now that you have had the opportunity to read how scholarly methodologies are written, you will write a condensed 3-4 page methodology section for your research question using the required headings from the 

Discussion Points:

●    Discuss Alignment, Hierarchy, Contrast, Repetition, Proximity, Balance, Space. What role do each of them play in design? Illustrate with examples.
●    How does knowledge of the basics of visual design help designers to follow design principles? ●    Explain the need, process of creation and essential components of the storyboard or wireframe of the digital product of your choice. What are essential components of the storyboard and wireframe? Illustrate with examples. 

https://www.youtube.com/watch?v=ZT8uSJojmqw&t=2s

https://www.youtube.com/watch?v=6EmjRXUcARc&feature=emb_logo

Select a large retail business, and in a 2 page, APA 7th edition-formatted paper, address how an analytical customer relationship management (CRM) tool may help with customer churn prediction models as described in the above linked videos. How would business leaders utilize data gathered about their customers to customize and target advertising? How would prediction models help in decision-making regarding promotions to offer or other methods to help retain customers and reduce churn? 

Note: 400 words with 4 references minimum and intext citations needed.

Exp19_Excel_Ch06_ML1_Housing_Cost

Exp19 Excel Ch06 ML1 Housing Cost

Excel Chapter 6 Mid-Level 1 – Housing Cost

Project Description:

Your friends, Elijah and Valerie Foglesong, want to build their dream house. They identified tentative costs, but they cannot afford the $414,717 estimated cost. You will use Goal Seek to determine an estimate of the total finished square footage they can afford. To help provide more flexibility in their decision-making, you will create a data table listing various finished square footages and their effects on the base house cost and total cost. Finally, you will create another data table showing combinations of square footages and lot prices to identify total costs.

Start   Excel. Download and open the file named Exp19_Excel_Ch06_ML1_HW-Housing   Cost.xlsx.   Grader has automatically added your last name to the beginning of the   filename. 

Assign the range names B9 (Base), B15 (Interior), B21 (Exterior), B23 (Lot).

Enter a formula in cell B25 to   calculate the total estimated cost. The total estimated cost is the sum of   the base house price (B9), total interior upgrades (B15), total exterior   upgrades (B21), and lot fee (B23). Be sure to use range names in the formula.

Use Goal Seek to determine the   total finished square footage(B7) to meet the total cost goal of $350,000.

Enter a series of total square   footage ranging from 1,800 to 3,600 in increments of 200 in the range D6:D15. Apply Blue font and Comma Style with   zero decimal places to the series.

Enter a reference to the base   house price in cell E5 and a reference to the total estimated cost in cell   F5.

Complete the single variable   data table in the range D5:F15. Be sure to use total square footage as the   column input. Apply Custom number formats to give appropriate descriptions to   the second and third columns. Apply these formats to the headings: bold,   center, and Blue font color.

Identify the square footage,   base price, and total cost in the data table that comes closest to their   goal. Apply Yellow fill color to those cells.

Copy the square footage   substitution values, range D6:D15 to the range H6:H15 and remove the fill   color. Enter these lot price substitution values in the range I5:K5: 90000, 96000, and 102675. Format these values with Accounting Number Format with zero   decimal places and Blue font color.

Enter the reference to the total   estimated cost in the appropriate location for the second data table. Apply a   custom number format to display Total Sq Ft in that cell. Apply Blue font and bold to that   cell.

Complete the two-variable data   table using total square footage as the Column Input and lot price as the Row   Input. Apply a Custom number format to the reference to the formula cell.   Apply Yellow fill color to the total price in each column that comes closest   to their goal.

Format results in both tables   with Accounting Number Format with zero decimal places.

Create a scenario named Ideal Costs, using Base price per square   foot and Lot fee (use cell references). Enter these values for the scenario: 80, 102,675.

Create a scenario named Increased   Costs, using   Base price per square foot and Lot fee (use cell references). Enter these   values for the scenario: 100, 110,000.

Create a scenario named Low Costs, using Base price per square   foot and Lot fee (use cell references). Enter these values for the scenario: 60, 80,000.

Generate a scenario summary   report using the cell references for Price per square foot and Lot Fee. Add   the appropriate formatting to the newly created report

Save and close Exp19_Excel_Ch06_ML1_HW-Housing Cost.xlsx.   Exit Excel. Submit the file as directed.

An aerospace company has decided to update their technology to something more modern and efficient. The segment of the task that requires your attention is in regard to the inventory system. This system will need to collect information and store it into a database for each aircraft. This particular segment focuses on the wheel assembly.

Description: An aerospace company, called AAC, is restructuring its internal technology processes. AAC is a large corporation that develops and assembles airplanes and cutting-edge craft for several markets, including commercial and defense. These craft include large passenger jets, attack aircraft, as well as spaceflight technologies.

The company has chosen to create a new database system to manage its incredibly large and complex parts inventory.

You work as an application software designer for an international corporation that has received the contract to create the system, IBN. You are the primary designer and business interface between IBN and AAC. You will design the User Interfaces that will be implemented.

IBN’s specialists have already determined which software language and database that the application will be created with. In addition, they have determined the first two modules that will be implemented: – Aircraft Information Entry and Wheel Assembly Subsystems.

Aircraft Basic Information Entry: These screens will allow for creating and editing of a new aircraft. It will include the aircraft name, first assembly date, chief designer, description of use, the primary customer, and a list of parts suppliers.

Wheel Assembly Subsystems: These screens will allow for the entry of all parts required for the assembly, the number on-hand, the price for the part, and a description of the part.

Deliverables:

1. You will inform AAC as to the database and software language chosen by IBN to create their new application, in written form. You must detail the reasons that this database and language were chosen, without being overly technical to the AAC Technology Committee that you will be interfacing with. 

a. A single Word document detailing these requirements is sufficient. Expert sources from Deets Library and other professional credible sources will be required to substantiate these requirements. Therefore, the sources will need to be cited to acknowledge credit for their contributions for concepts, ideas, and facts. 

2. You must develop the database for the first phase of the project, providing the data structure for Aircraft Basic Information Entry, and the Wheel Assembly Subsystems. Tables should follow standard entity-relationship industry practices.

a. Submit an entity-relationship diagram detailing data structure

b. Provide a backup file of the database with your implemented data structure

3. You must develop and deliver the operational front-end that allows for the entry of the data into the first phase screens, in the language that you choose. It must be operational and connect to the database that you created in Deliverable #2.

a. Provide all code and files in zip archive, required to run the project

4. You must provide the above documentation from Deliverable #1, with installation instructions for implementing your First Phase deliverables for items #2 and #3.

a. Provide installation instructions to implement the system. This can be a single Word document

 Xcode is the application used to develop an iOS app. An Xcode project is the source for an app; it’s the entire collection of files and settings needed to construct the app.  Apple has propelled the world into the mobile boom as it constantly is innovating and creating new boundaries within the mobile industry.  When developing mobile apps, choosing one platform helps developers focus their skills.  However, beware as this may also “lock” developers into that platform.  Whatever iOS fits into the mobile app strategy, be aware Apple has a large market share and will be around for a long time.

• What specific features do you enjoy most about iOS?
• Why are Storyboards great features to use in iOS development?
• Why is “automatic reference counting” considered a type of garbage collection mechanism?

cite using Bibtex 

preferably done on overleaf 

Book to Market Ratios in pandas

Read the Exam-Ford_Accounting.csv file into a pandas dataframeNow read in the Exam-Ford_Price_Shares.csv file into another pandas dataframeFor each dataframe, make year the index so that we can easily add/subtract/multiple/divide, etc. across the two dataframes and the years will be lined up correctly. Note that you don’t have to convert anything into a datetime.The Book-to-Market ratio is the Book value of equity divided by the market value of equity.In this case, shares are listed in thousands and the accounting data are in millions, so let’s divide shares by 1000 so that they are also in millions.ME (Market value of equity in millions) = price * (shares/1000)Create a market value of equity column in the dataframe with prices and shares.Now calculate the book to market ratio using the book value of equity and the market value of equity. You’ll have to use columns from both dataframes.Show the summary statistics (i.e., mean, standard deviation, min, max, etc.)Set all negative values equal to zeroNow what are the summary statistics?Plot out Ford’s Book-to-Market ratio over time.

(At least) One slide for each topic below. Reference is suggested below. You can use additional references if needed. 

No images. No bullets. Need more description. 

Topics:

1. What are the different tools used in optimizing web pages? How are they designed?

Reference:

Terrance, A. R., Shrivastava, S., Kumari, A., & Sivanandam, L. (2018). Competitive Analysis of Retail Websites through Search Engine Marketing. Ingeniería Solidaria, 14(25), 1-14.

2. Which tools are best suited for optimizing pages?

Reference:

Ziewitz, M. (2019). Rethinking gaming: The ethical work of optimization in web search engines. Social studies of science, 49(5), 707-731.