Posts

Metode Statistik untuk Ilmu dan Teknologi Pangan

Image
ARA Djamaris Publication date 2018 Publisher Download E-book Description Buku ini terdiri 7 bagian dan memberikan contoh soal dan pertanyaan untuk pendalaman materi. Isi buku ini adalah statistik aplikatif dimana setiap kasus disajikan dengan menggunakan bantuan program komputer yaitu Mircosoft Excel dan SPSS. Buku ini juga memberikan penjelasan tentang statistik yang umum digunakan dalam proses pengolahan, pengembangan produk dan juga perilaku konsumen. Khusus untuk BAB 7 tentang evaluasi sensori dan data konsumen hanya menjelaskan secara umum, penjelasan lebih detail tentang ini akan dijelaskan pada buku terpisah. Pada kesempatan ini penulis ingin mengucapkan terima kasih kepada sivitas akademika Universitas Bakrie atas saran dan masukannya selama penulisan dan penerbitan buku ini. Besar harapan penulis semoga buku ini bermanfaat dan tentunya tidak ada gading yang tidak retak, maka penulis juga membuka kritik dan saran dari pembaca. Selamat membaca.

Statistika Bisnis

Image
This is a playlist on YouTube that contains 19 videos on  Excel Basic & Intermediate . The playlist is created by Aurino Djamaris and covers topics such as creating Excel equations and graphs, data analysis, and formatting tables. 

Excel Basic & Intermediate

Image
This is a playlist on YouTube that contains 19 videos on  Excel Basic & Intermediate . The playlist is created by Aurino Djamaris and covers topics such as creating Excel equations and graphs, data analysis, and formatting tables.  You can access the playlist at  1 .

Excel Data Validation: Preventing Duplication in User Sheets

Excel is a powerful tool that allows users to manage and analyze large amounts of data. One of the most useful features of Excel is data validation, which ensures that the data entered into a spreadsheet meets certain criteria. This article will focus on how to use data validation to prevent duplication in user sheets. 1. What is Data Validation?           Data validation is a feature in Excel that allows you to define restrictions on what data can or cannot be entered into a cell. You can configure data validation to prevent users from entering invalid data or data that doesn't conform to specific rules. 2. Preventing Duplication with Data Validation One common use of data validation is to prevent duplicate entries in a column. This is particularly useful when you're dealing with large datasets and need to ensure that each entry is unique. Here's how you can set up data validation to prevent duplicates: Step 1: Select the Range First, select the range of cells where you wa

Unveiling the Potential of Excel's Goal Seek Function: Business Applications and Examples

Microsoft Excel, for decades, has been a powerful tool in the arsenal of business and data professionals. Among its multitude of functions and features, one particularly compelling tool is Goal Seek. Primarily used for decision making and problem solving, Goal Seek is the hidden gem that every business should master. ## What is Goal Seek? Goal Seek is an Excel function that allows you to find the necessary input value to attain a desired output. It's an excellent tool when you know the desired result, but are unsure about the inputs required to achieve it. For instance, if you want to reach a specific profit level but are uncertain how much sales volume is required, Goal Seek can provide the answer. ## How to Use Goal Seek in Excel To access Goal Seek, navigate to the 'Data' tab in Excel and select 'What-If Analysis' under the 'Forecast' group. Then select 'Goal Seek'. You'll then need to fill out three fields: 1. **Set Cell:** The cell you want

Resolving Jakarta's Traffic Congestion: Exploring the Expansion and Decentralization of Business and Government Centers

Title: Resolving Jakarta's Traffic Congestion: Exploring the Expansion and Decentralization of Business and Government Centers Introduction: Addressing the severe traffic congestion in Jakarta requires a comprehensive and strategic approach. One potential solution is the expansion and decentralization of business and government centers from Jakarta to other regions. This article will delve deeper into this approach, examining the potential benefits and challenges associated with it. 1. Development of Robust Infrastructure: A crucial aspect of expanding and decentralizing business and government centers is the development of strong infrastructure. This entails building well-planned roads, bridges, railways, and efficient public transportation systems in the surrounding areas. By improving accessibility and transportation options, individuals will have viable alternatives for work and activities outside of Jakarta's central area, alleviating the strain on the city's main road